am having problem with my SUM function. I tried summing up some figures in a column but is not returning the total of the figures. this is my syntax
$creditbal=mysql_query("SELECT SUM($column), FROM $table WHERE status='P'");
but is not echoing any out any, what can i do.