Loop problem

[jonnym]

I'm trying to loop through a recordset. The total rows is 9 but the loop is starting at 1 instead of 0 and when $i gets to 9, nothing is displayed. What am I doing wrong? Thanks in advance!

$handlesql = "SELECT * FROM products2 WHERE class = 'sticks' and subclass = 'Handles' AND item_size3 = 'Goalie' order by manufacturer, item_name";

$query_rs = sprintf($handlesql);
$rs2 = mysql_query($query_rs, $lax) or die(mysql_error());
$row = mysql_fetch_assoc($rs2);
$totalRows_rs = mysql_num_rows($rs2);

for($i=0; $i < mysql_num_rows($rs2); $i++)
{
	 $row = mysql_fetch_array($rs2);

echo $i."<br />";
echo $row ['manufacturer'].$row ['item_name']. "<br>\n";

}

[olaf]

do this:

$i = 1;
do
{ 

echo $i."<br />"; 
echo $row ['manufacturer'].$row ['item_name']. "<br>\n"; 
$i++;
}
while ($row = mysql_fetch_assoc($rs2));

[laserlight]

May I suggest a change to this instead?

$handlesql = "SELECT * FROM products2 WHERE class = 'sticks' and subclass = 'Handles' AND item_size3 = 'Goalie' order by manufacturer, item_name";

$query_rs = sprintf($handlesql);
$rs2 = mysql_query($query_rs, $lax) or die(mysql_error());
$totalRows_rs = mysql_num_rows($rs2);

$i = 0;
while ($row = mysql_fetch_assoc($rs2))
{
	echo $i."<br />";
	echo $row ['manufacturer'] . $row ['item_name'] . "<br>\n";
}

Your current script calls mysql_fetch_assoc(), which in this case is equivalent to mysql_fetch_array(), once before the loop.

You could still use a for loop, but then you must call mysql_num_rows() first.
Using a while loop, you may remove the mysql_num_rows() call if it is not necessary.