So, I cant seem to get the result from this. It’s returning a blank message. Any help
[php]<?php
include(‘dbconnect.php’);
$query="SELECT commission FROM sales WHERE status='Approved' ORDER BY id ASC";
$result=mysql_query($query);
while ($row = mysql_fetch_array($result))
{
$amount++;
$totalAmount= $row["SUM(commission)"];
print “”.$totalAmount."";
}
?>[/php]