probs with my criminal.php

[prototype]

This prob is solved

Edited December 2, 2011 by prototype

[Casey]

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();
?>

[lucky3809]

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

[prototype]

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

[Dominion]

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?