data not appearing

[Anon]

Hi,
I am creating a database driven web site using php and mysql.
I have created one table in mysql with 3 rows but when I go to view this info in the browser window, only two of the three rows of data show up. Can anyone help?
My code is:

<?php

error_reporting(E_ALL ^ E_NOTICE);

$db = mysql_connect("localhost", "root");

mysql_select_db("frame",$db);

$result = mysql_query("SELECT * FROM items",$db);

$count = count($result);
for($i = 0; $i <= $count; $i++) {
print($i);
print("<tr><td width= colspan='1' width='150px'>");
printf("<a href='/pf/Images/%s'><img src='/pf/Images/thumb/%s%s%s",
mysql_result($result,$i,"ItemFull"),
mysql_result($result,$i,"ItemThumb"),
"'>",
"</a><td colspan=1 width='150px'>&nbsp;</td></tr>");

}

?>

Thanks in advance,
Dee

[vsego]

$count = count($result);

$result is not an array, but is set, so (according to manual) it returns 1. Your for(;😉{} will always run 2 times.

$result = mysql_query("SELECT * FROM items",$db);

while ($row = mysql_fetch_row($result)) {
print("<tr><td width=\"150\">");
printf("<a href=\"/pf/Images/%s\"><img src=\"/pf/Images/thumb/%s\"></a><td width=\"150\">&nbsp;</td></tr>", $row["ItemFull"], $row["ItemThumb"]);
}