Code: Select all
<?php
$sql2 = "SELECT * FROM mapitems WHERE userid='1'";
$result2 = mysql_query($sql2, $conn) or die(mysql_error());
$total = mysql_num_rows($result2);
for($i=1;$i<(51-$total);$i++) {
$sql = "SELECT * FROM mapitems WHERE userid='1' AND squareid='$i' ORDER BY squareid ASC";
$result = mysql_query($sql, $conn) or die(mysql_error());
while($r = mysql_fetch_array($result)) {
$squi = $r['squareid'];
}
if(!$squi) {
echo "$i\n";
}
}
?>