prototype Posted June 9, 2011 Share Posted June 9, 2011 (edited) This prob is solved Edited December 2, 2011 by prototype Quote Link to comment Share on other sites More sharing options...
Casey Posted June 9, 2011 Share Posted June 9, 2011 i dont no why just try this code <?php $macropage="criminal.php"; include_once "globals.php"; if($ir['jail'] or $ir['hospital']) { echo 'This page cannot be accessed while in jail or hospital.'; } $q2=$db->query("SELECT * FROM crimes ORDER BY crimeBRAVE ASC"); while ($r2=$db->fetch_row($q2)) { $crimes[]=$r2; } $q=$db->query("SELECT * FROM crimegroups ORDER by cgORDER ASC"); echo '<b>Criminal Centre</b><br /> <table width="75%" cellspacing=1 class="table"> <tr><th>Crime</th> <th>Cost</th> <th>Do</th> </tr>'; while($r=$db->fetch_row($q)) { echo '<tr><td colspan="3" class="h">'.mysql_real_escape_string($r["cgNAME"]).'</td></tr>'; foreach($crimes as $v) { if($v['crimeGROUP'] == $r['cgID']) { echo '<tr><td>'.mysql_real_escape_string($v["crimeNAME"]).'</td>'; echo '<td>'.$v["crimeBRAVE"].' Brave</td>'; echo '<td><a href="docrime.php?c='.$v['crimeID'].'">Do</a></td></tr>'; } } } echo "</table>"; $h->endpage(); ?> Quote Link to comment Share on other sites More sharing options...
lucky3809 Posted June 9, 2011 Share Posted June 9, 2011 (edited) Have you created a crime in your staff panel? If you have not created a crime it will show NOTHING... I dont see anything wrong with your script. @Casey echo and print statements do not need to be secured with mres... there is no need for that... only queries and forms... echo/print is just shooting out what is in your database... securing your queries it should have already filtered it before it echo'd/print it... just saying... Edited June 9, 2011 by lucky3809 Quote Link to comment Share on other sites More sharing options...
prototype Posted June 25, 2011 Author Share Posted June 25, 2011 i know there is nuthing wrong in the code coz i own 1 more game and the host is also same bt in tht game there is no probs Quote Link to comment Share on other sites More sharing options...
Dominion Posted June 25, 2011 Share Posted June 25, 2011 i know there is nuthing wrong in the code coz i own 1 more game and the host is also same bt in tht game there is no probs If there's nothing wrong with it what's the point in this thread? 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.