While within a while?

[msavvy]

Why can't I do a while fetch_object loop within another while fetch_object loop?

<?php
while ($rowAllAttributes = mysql_fetch_object($resultAllAttributes)) {

$attributeUID = $rowAllAttributes->UID;
echo "<input type=\"checkbox\" name=\"" . $attributeUID . "\"";

while ($rowAttributes = mysql_fetch_object($resultAttributes)) {
if ($attributeUID == $rowAttributes->UID) { echo " CHECKED"; }
}

echo ">";
echo "&nbsp;&nbsp;" . $rowAllAttributes->name . "<br>\n";

}
?>

[seby]

i dont think you need to add a while() within a while() .. the second fetch will loop since its already inside a while.

try:

while ($rowAllAttributes = mysql_fetch_object($resultAllAttributes))
{ 
	$attributeUID = $rowAllAttributes->UID; 
	echo "<input type=\"checkbox\" name=\"" . $attributeUID . "\""; 

$rowAttributes = mysql_fetch_object($resultAttributes);

if ($attributeUID == $rowAttributes->UID)
{ 
	echo " CHECKED"; 
} 

echo ">" . $rowAllAttributes->name . "<br>\n"; 

} 

[ahundiak]

You need to reset the inner result set

 while ($rowAttributes = mysql_fetch_object($resultAttributes)) 
{
  /* Blah Blah */
}
mysql_data_seek($resultAttribute,0);