loop problem

[jonnym]

While displaying a recordset, I loop through a portion of the code. After I close the loop, I can't display any more results of the recordset.

// Here is the loop...
	do{
		if(strchr($row_rs['item_size'], ","))
			{
			//split sizes
			$item_size = $row_rs['item_size'];
			$item_size2 = split(",", $item_size);
			while (list($key, $value) = each ($item_size2))
				{
				echo $row_rs['stock_no']." ";
				echo $value."<br>\n";
				echo "<input type=\"radio\" name=\"stock_no\" value=\"".$value."\">";
				echo "<strong>".$row_rs['price']."</strong>";
				echo "<hr>\n";
				}
			}
			else
			{
					echo $row_rs['stock_no']." ";
				echo $row_rs['item_size']." ";
				echo "<br>";
				echo "<input type=\"radio\" name=\"stock_no\" value=\"".$row_rs['stock_no']."\">";
				echo "<strong>".$row_rs['price']."</strong>";
				echo "<hr>\n";
			}
		 } while ($row_rs = mysql_fetch_assoc($rs));
// the loop ends above.
}
else
{
	echo $row_rs['stock_no']. "&nbsp;&nbsp;&nbsp;&nbsp;<strong>".$row_rs['price']."</strong>";
}
// this will not display
echo "<br>Color: ". $row_rs['color'];

[ahundiak]

When you exit the while loop $row_rs will be null. In fact, that is what is causing the loop to exit in the first place.

I can't really tell what you are trying to do.

If you need to go back through the result set a second time then use mysql_data_seek to reset $rs.

If you want the last record processed then stick a
$row_rs_last = $row_rs at the top of the while loop.

Note: I just updated this. I had mysql_seek instead of mysql_data_seek. Thanks kevinsequeira.

[jonnym]

What is mysql_seek and what is the syntax for using it?

[kevinsequeira]

http://www.php.net/manual/en/function.mysql-data-seek.php

reg
kevin

[jonnym]

I have 2 records returned. I want to first loop through the sizes. Then go back and display some other info.

	do{
		echo $row_rs['item_size']. "<br>";
    } while ($row_rs = mysql_fetch_assoc($rs));

// How can I get this to display

echo "<br>Color: ". $row_rs['color'];

[ahundiak]

$rs = mysql_query("Select everything from everwhere");
while($rs_row = mysql_fetch_assoc($rs))
{
  /* Process 1 */
}
/* Reset the record set */
mysql_data_seek($rs);
while($rs_row = mysql_fetch_assoc($rs))
{
  /* Process 2 */
}

[jonnym]

I get the following error on this code:

Warning : Wrong parameter count for mysql_data_seek() in /opt/web/website/webshare/item-2.php on line 27

Fatal error : Call to undefined function: _mysql_fetch_assoc() in /opt/web/website/webshare/item-2.php on line 28

do{
	echo $row_rs['item_size']. "<br>";
   } while ($row_rs = mysql_fetch_assoc($rs));
// line 26
mysql_data_seek($rs);
while($rs_row_=_mysql_fetch_assoc($rs))
{
	echo "<br>Color: ". $row_rs['color'];
}

Any suggestions?

[laserlight]

Probably should try:

do {
	echo $row_rs['item_size']. "<br>";
} while ($row_rs = mysql_fetch_assoc($rs));
// line 26
mysql_data_seek($rs, 0);
while($rs_row = mysql_fetch_assoc($rs))
{
	echo "<br>Color: ". $rs_row['color'];
}

I dont understand why ppl use do while loops for this sort of thing though, while loops seem more appropriate.
Anyhow, there might be a better way of doing this, perhaps by placing the required values into an array on a single loop, then looping through this array for the output.
Then again it might be slower with looping 3 times instead of twice, but that would depend on how expensive mysql_fetch_assoc() and mysql_data_seek() are.