Ik heb het getal juist bewust in een aparte variabele gezet, maar dat blijkt niet te helpen, wat moet ik doen?
script:
<?php
$query1 = "SELECT * FROM bingonu WHERE username = '".$user."' AND kaartnr = 1 AND ronde = '".$rondea."' ORDER BY getallen ASC LIMIT 0,25";
$result1 = mysql_query($query1) or die (mysql_error());
while ($row = mysql_fetch_assoc($result1))
{
$cijfers[] = $row['getallen'];
}
for ($p = 1; $p <= 5; $p++)
{
echo '<tr><td style="background-color: #0066FF;"> </td>';
for ($i = 1; $i <= 5; $i++)
{
// echo van de td
if ($i == 3 && $p == 3) //controleren of de geldzak weergegeven moet worden
{
echo '<td style="background-image: url(images/yellow_space.png); background-repeat:no-repeat; background-position: center;" width="50" height="50" align="center" valign="middle"><img src="images/moneybag.png" border="0" /></td>';
}
else
{
$cijfer = array_shift($cijfers); //volgende getal in de array aanspreken
//controleren of dit getal getrokken is
$query2 = "SELECT COUNT(*) AS aantal FROM trekking WHERE getal = ".$cijfer;
$result2 = mysql_query($query2) or die (mysql_error());
$trekking = mysql_result($result2,0,'aantal');
if ($trekking > 0)
{
echo '<td style="font-weight: bold; background-image: url(images/yellow_space.png); background-repeat:no-repeat; background-position: center;" width="50" height="50" align="center" valign="middle">'.array_shift($cijfers).'</td>';
}
else
{
echo '<td style="background-image: url(images/yellow_space.png); background-repeat:no-repeat; background-position: center;" width="50" height="50" align="center" valign="middle">'.$cijfer.'</td>';
}
}
echo '</td>';
}
echo '<td style="background-color: #0066FF;"> </td></tr>';
}
?>