rendered paste body$bingo1 = mysql_query("SELECT * FROM bingo_cards ORDER BY rand() LIMIT 3") or die(mysql_error());
while($row = mysql_fetch_assoc($bingo1))
{
if($row['num'] <= 9 AND $row['num1'] <= 9)
{
$col1 = array("rule1-9" => array("".$row['num']."", "".$row['num1'].""));
}
if($row['num1'] >= 10 AND $row['num1'] <= 19 AND $row['num2'] >= 10 AND $row['num2'] <= 19 AND $row['num3'] >= 10 AND $row['num3'] <= 19)
{
$col2 = array("rule10-19" => array("".$row['num1']."", "".$row['num2']."", "".$row['num3'].""));
}
if($row['num4'] >= 20 AND $row['num4'] <= 29 AND $row['num5'] >= 20 AND $row['num5'] <= 29)
{
$col3 = array("rule20-29" => array("".$row['num4']."", "".$row['num5'].""));
}
if($row['num5'] >= 30 AND $row['num5'] <= 39 AND $row['num6'] >= 30 AND $row['num6'] <= 39 AND $row['num7'] >= 30 AND $row['num7'] <= 39)
{
$col4 = array("rule30-39" => array("".$row['num5']."", "".$row['num6']."", "".$row['num7'].""));
}
if($row['num7'] >= 40 AND $row['num7'] <= 49 AND $row['num8'] >= 40 AND $row['num8'] <= 49 AND $row['num9'] >= 40 AND $row['num9'] <= 49)
{
$col5 = array("rule40-49" => array("".$row['num7']."", "".$row['num8']."", "".$row['num9'].""));
}
if($row['num9'] >= 50 AND $row['num9'] <= 59 AND $row['num10'] >= 50 AND $row['num10'] <= 59)
{
$col6 = array("rule50-59" => array("".$row['num9']."", "".$row['num10'].""));
}
if($row['num10'] >= 60 AND $row['num10'] <= 69 AND $row['num11'] >= 60 AND $row['num11'] <= 69 AND $row['num12'] >= 60 AND $row['num12'] <= 69)
{
$col7 = array("rule60-69" => array("".$row['num10']."", "".$row['num11']."", "".$row['num12'].""));
}
if($row['num12'] >= 70 AND $row['num12'] <= 79 AND $row['num13'] >= 70 AND $row['num13'] <= 79 AND $row['num14'] >= 70 AND $row['num14'] <= 79)
{
$col8 = array("rule70-79" => array("".$row['num12']."", "".$row['num13']."", "".$row['num14'].""));
}
if($row['num14'] >= 80 AND $row['num14'] <= 90 AND $row['num15'] >= 80 AND $row['num15'] <= 90)
{
$col9 = array("rule80-90" => array("".$row['num14']."", "".$row['num15'].""));
}
$id = $row['id'];
}
?>
<?=$id?>
<pre>
<?php
print_r($col1);
print_r($col2);
print_r($col3);
print_r($col4);
print_r($col5);
print_r($col6);
print_r($col7);
print_r($col8);
print_r($col9);
?>
</pre>
<table border="1" width="100%">
<tr>
<td><?=$col1['rule1-9'][0]?></td><td><?=$col2['rule10-19'][0]?></td><td><?=$col3['rule20-29'][0]?></td><td><?=$col4['rule30-39'][0]?></td><td><?=$col5['rule40-49'][0]?></td><td><?=$col6['rule50-59'][0]?></td><td><?=$col7['rule60-69'][0]?></td><td><?=$col8['rule70-79'][0]?></td><td><?=$col9['rule80-90'][0]?></td>
</tr>
<tr>
<td><?=$col1['rule1-9'][1]?></td><td><?=$col2['rule10-19'][1]?></td><td><?=$col3['rule20-29'][1]?></td><td><?=$col4['rule30-39'][1]?></td><td><?=$col5['rule40-49'][1]?></td><td><?=$col6['rule50-59'][1]?></td><td><?=$col7['rule60-69'][1]?></td><td><?=$col8['rule70-79'][1]?></td><td><?=$col9['rule80-90'][1]?></td>
</tr>
<tr>
<td><?=$col1['rule1-9'][2]?></td><td><?=$col2['rule10-19'][2]?></td><td><?=$col3['rule20-29'][2]?></td><td><?=$col4['rule30-39'][2]?></td><td><?=$col5['rule40-49'][2]?></td><td><?=$col6['rule50-59'][2]?></td><td><?=$col7['rule60-69'][2]?></td><td><?=$col8['rule70-79'][2]?></td><td><?=$col9['rule80-90'][2]?></td>
</tr>
</table>
</td>