$q=$db->query("SELECT * FROM crimes WHERE crimeBRAVE <= {$ir['brave']} AND (crimeCITY = 0 OR crimeCITY = {$ir['location']}) ORDER BY crimeBRAVE");
					if($db->num_rows($q) == 0) {
						echo "<tr><td colspan='2'><p class='o c'>There are currently no crimes to commit!</p></td></tr>";
					}
					else {
						while($c=$db->fetch_row($q)) {

							$XP = round($c['crimeXP'] / 2, 1/2);

							echo "
							<tr>
							<td><a href='crime_commit.php?c={$c['crimeID']}' class='crimes'>{$c['crimeNAME']}<span><b>Exp:</b>&nbsp;{$XP} & <b>Money:</b>&nbsp;{$c['crimeSUCCESSMUNY']}</span></a></td>
							<td align='right'>{$c['crimeBRAVE']} Brave</td>
							</tr>";
						}
					}