[SOLVED] mysql_fetch_array and counting

[Mundo]

if($_GET['module'] == "add") {
include "tpl/addtodiary.tpl";
if(isset($_GET['submit'])) {
	$result = mysql_query(sprintf("SELECT diary_duration FROM diary WHERE diary_date = '$_GET[date]'"));
	while($row = mysql_fetch_array($result)) {
		echo $row['diary_duration'];
		}
	}
}

 

This creates and array and outputs it to screen, how can I add all these results together? I'm making a booking system so I need to see if there is time available on selected day... Is there a add() function or something similar?

[Maq]

If I understand you correctly use:

 

$result = mysql_query(sprintf("SELECT SUM(diary_duration) FROM diary WHERE diary_date = '$_GET[date]'"));
$row = mysql_fetch_array($result)
echo $row['SUM(diary_duration)'];

[alphanumetrix]

Are you trying to create a loop? If so, try the foreach function.

[Mundo]

If I understand you correctly use:

 

$result = mysql_query(sprintf("SELECT SUM(diary_duration) FROM diary WHERE diary_date = '$_GET[date]'"));
$row = mysql_fetch_array($result)
echo $row['SUM(diary_duration)'];

 

So you think:

 

if($_GET['module'] == "add") {
include "tpl/addtodiary.tpl";
if(isset($_GET['submit'])) {
	$result = mysql_query(sprintf("SELECT diary_duration FROM diary WHERE diary_date = '$_GET[date]'"));
	$row = mysql_fetch_array($result);
	echo $row['SUM(diary_duration)'];
	}
}

 

Because that just returns a blank.

[Mundo]

Well i'm not necessarilly trying to use a loop... I just thought I would have to.

 

I'm trying to get the SUM of everything in the diary_duration column.

[Maq]

You didn't change this line...:

 

$result = mysql_query(sprintf("SELECT SUM(diary_duration) FROM diary WHERE diary_date = '$_GET[date]'"));

[Mundo]

Ah, I didn't realise that that had been changed. Thanks again, you've really helped me today.

[Maq]

Ah, I didn't realise that that had been changed. Thanks again, you've really helped me today.

 

No problem.

 

Are you trying to create a loop? If so, try the foreach function.

 

He already had a while loop to display each diary_duration but he wanted the sum of all of them, and MySQL has a simple built in SUM function.