arn_php Posted March 23, 2009 Share Posted March 23, 2009 Continuously from my previous post.. now I am trying to get this calculate together.. <? $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); $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); $total = $sum2-$sum echo "# of tickets being purchased are $sum"; echo "<br />Limit of the ticket are $sum2"; echo "<br />Total of the available tickets are $total"; ?> It doesn't work and even it put my page blank again? ha.. please help... Anyone... Link to comment https://forums.phpfreaks.com/topic/150736-solved-php-math-trying-to-get-a-total-result/ Share on other sites More sharing options...
arn_php Posted March 23, 2009 Author Share Posted March 23, 2009 Sorry, found my own error.. $total = $sum2-$sum; Link to comment https://forums.phpfreaks.com/topic/150736-solved-php-math-trying-to-get-a-total-result/#findComment-791921 Share on other sites More sharing options...
rhodesa Posted March 23, 2009 Share Posted March 23, 2009 you should turn on error reporting in your php.ini file edit: for next time Link to comment https://forums.phpfreaks.com/topic/150736-solved-php-math-trying-to-get-a-total-result/#findComment-791923 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.