Newbie PHP/MYSQL SUM help needed

dinaciccone

I am trying to output my data but at the same time total a column for output which will be sorted by date. I have tried to do multiple select statements to no avail. below is my code with my data outputted but i cannot get it to total my column and output that as well. PLEASE HELP I AM A SELF TAUGHT NEWBIE

$table = "test";
mysql_connect($db_host, $db_user, $db_pwd);
mysql_select_db($db_name)or die( "Unable to select database");

$query="SELECT * FROM $table";
$result=mysql_query($query);

$num=mysql_numrows($result);

$i=0;
while ($i < $num) {
$date=mysql_result($result,$i,"date");
$food=mysql_result($result,$i,"food");
$points=mysql_result($result,$i,"points");
?>

</tr>

<?
$i++;
}

echo "</table>";
?>

rulian

$num=mysql_num_rows($result)
not
mysql_numrows

to order by date simply add a order by clause in your sql

$query="SELECT * FROM $table ORDER BY date DESC"; OR ASC if you want it from oldest to newest

and also, if your tablename wont change there is not need to make it a variable
$query="SELECT * FROM test ORDER BY date DESC";

and in your while statement, i would do an qual as well in case you are missing one table row from actual rows retrieved by the database
while ($i <= $num)

krotkruton

Newbie tip #1: If you're going to post a bunch of code, put php tags around it. They look like [ + PHP + ] and [ + / + PHP + ] (without the spaces and pluses). Also, if rulian answered your question, mark the thread as "resolved" so people know you got an answer.