displaying multiple mysql records in one html row using php

Howdy folks,

I am trying to get three rows from a mysql query result to print in three seperate columns in one row of an html table.

I used a tutorial and came up with:



<?php

$result = mysql_query("
SELECT
A.ID,
A.style,
A.tn,
A.desc
FROM
A
WHERE
A.ID >0");
if($r = mysql_fetch_array($result))
{
print("<table>");
print("<tr>");
$num = @mysql_num_rows($result);
$thumbcols = 3;
$thumbrows = 1+ round($num / $thumbcols);
function display_table() {
global $num, $result, $thumbrows, $thumbcols;
for($r=1;$r<=$thumbrows;$r++) {
print '<tr>';
for($c=1;$c<=$thumbcols;$c++) {
print '<td bgcolor="#999999" align="center" valign="top">';

printf("<a href=\"%s?ids=%s\"><img src=http://foobar.com/foobar/styles/%s></a><br>\n", $PHP_SELF, $r["ID"], $r["tn"]);
printf("<a href=\"%s?ids=%s\">%s</a><br>\n", $PHP_SELF, $r["ID"], $r["style"]);


print("</td>");
}
print("</tr>");
}
}
display_table();
print("</table>");
}
else {
print '&nbsp;';
} ?>

Problem is, this prints a very long list of imageless tn's.

Any ideas??? Suggestions much appreciated.