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... Quote Link to comment 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; Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.