cant get SUM to work with PHP
Posted: Sat Nov 13, 2004 4:58 pm
im trying to TOTAL up the "adminprofits" field in sql database and display it, but it wotn work
echo "<strong>Admin Profits:</strong> ";
$mysql_result = mysql_query("SELECT SUM(adminprofits) FROM sales");
echo "$mysql_result<br /><br />";
please help, thanks
echo "<strong>Admin Profits:</strong> ";
$mysql_result = mysql_query("SELECT SUM(adminprofits) FROM sales");
echo "$mysql_result<br /><br />";
please help, thanks