Esmu izveidojis šādu kodu. Gribētu lai piemēram uzpiežot uz Australia attēlotos kā id_race 1 utt.
<?php
$db = mysql_connect("localhost", "user", "pasword");
mysql_select_db("f1c",$db);
$result = mysql_query("SELECT * FROM race_table WHERE id_race IN (1,2,3) ORDER BY id_race, r_place ",$db);
if ($myrow = mysql_fetch_array($result))
{
echo "<center><table></center>";
echo "<tr><td>Australia</td><td>Malaisya</td><td>China</td></tr>";
echo "</table>";
echo "<center><table cellpadding=1 cellspacing=1 bordercolor=black bgcolor=white border=1>\n";
echo "<tr>
<center><td><center><b>Trase</b></center></td>
<td><center><b>Braucejs</b></center></td>
<td><center><b>R<br>Vieta</b></center></td>
<td><center><b>Punkti</b></center></td>
<td><center><b>Komanda</b></center></td>
</tr>
\n";
do
{
printf("<tr>
<td><center>%s</center></td>
<td><center>%s</center></td>
<td><center>%s</center></td>
<td><center>%s</center></td>
<td><center><img src='/f1c/images/flag/car/". $myrow["driver_team"] .".png'></center></td>
</tr>
\n", $myrow["track"], $myrow["driver"], $myrow["r_place"], $myrow["points"], $myrow["driver_team"]);
}
while ($myrow = mysql_fetch_array($result));
echo "</center></table>\n";
}
else
{
echo "Sorry, no records were found!";
}
?>