I've been banging my head against this one and it seems like there should be a simple solution. Unfortunately, it is not presenting itself to me.
My ultimate goal is just to add the Number column from this data:
Name | Email | Number
test | firstname.lastname@example.org | 2
test | email@example.com | 1
test | firstname.lastname@example.org | 3
The MySQL query "SELECT SUM(number) FROM information" works in phpMyAdmin and the $sql variable is exactly what it spits out for php code, but all I get in return is the "Resource id #3".
@mysql_select_db($database) or die( "Unable to select database");
$sql = "SELECT SUM(number) FROM information";
$result = mysql_query($sql);