[SOLVED] PHP Sum, am I doing this correctly?

[arn_php]

Thanks for this great forum..

I am trying to put this code:

 

<?

$result = mysql_query("SELECT SUM(jumlah) FROM `gtown_eticket`") or trigger_error(mysql_error(),E_USER_ERROR);

$sum = mysql_result($result,0);

echo "# of tickets being purchased are $sum";

 

$result2 = mysql_query("SELECT batas FROM `gtown_events`") or trigger_error(mysql_error(),E_USER_ERROR);

$sum2 = mysql_result($result2,0);

echo "<br />Limit of the ticket are $sum2";

?>

 

into something like this:

<?

$result = mysql_query("SELECT SUM(jumlah) FROM `gtown_eticket` WHERE category=`$id` and flag_status=`1`") or trigger_error(mysql_error(),E_USER_ERROR);

$sum = mysql_result($result,0);

echo "# of tickets being purchased are $sum";

 

$result2 = mysql_query("SELECT batas FROM `gtown_events` WHERE events_id=`$id` and flag_status=`1` LIMIT 1") or trigger_error(mysql_error(),E_USER_ERROR);

$sum2 = mysql_result($result2,0);

echo "<br />Limit of the ticket are $sum2";

?>

 

The reason is the $id would determine which data entry would be pull and sum from either gtown_eticket and gtown_events. The problem is.. the page went blank!.. do you know where is the error?

 

Thanks.

[Mark Baker]

$result = mysql_query("SELECT SUM(jumlah) FROM `gtown_eticket` WHERE category='$id' and flag_status='1'") or trigger_error(mysql_error(),E_USER_ERROR);
$sum = mysql_result($result,0);
echo "# of tickets being purchased are $sum";

$result2 = mysql_query("SELECT batas FROM `gtown_events` WHERE events_id='$id' and flag_status='1' LIMIT 1") or trigger_error(mysql_error(),E_USER_ERROR);
$sum2 = mysql_result($result2,0);
echo "<br />Limit of the ticket are $sum2";

Use quotes for quoted values in the WHERE clause: backticks for table and column names

[arn_php]

I did that actually (and just tried again) but then the page still blank.

[arn_php]

funny..! I guess that is because my own fool... I forgot that I do not have "and flag_status='1' " field on the first table. I took it out and it works.

 

$result = mysql_query("SELECT SUM(jumlah) FROM `gtown_eticket` WHERE category='$id'") or trigger_error(mysql_error(),E_USER_ERROR);

$sum = mysql_result($result,0);

echo "# of tickets being purchased are $sum";

 

$result2 = mysql_query("SELECT batas FROM `gtown_events` WHERE events_id='$id' and flag_status='1' LIMIT 1") or trigger_error(mysql_error(),E_USER_ERROR);

$sum2 = mysql_result($result2,0);

echo "<br />Limit of the ticket are $sum2";