Not pulling back all rows

[thines]

Hi folks,

I am working with looping through a select and am stumpped. My option show all the rows except the first one. Why would this only return all the values except the first one? I run the query in PHPMySQL and it returns the correct data.

For example,
The table has 3 rows in it. It only populates the dropdown with two (the second and the third value). I want it to do all three.

By te way, first option that is not looped comes from a different table, and does not interfear.

Also, there is a loop that is creating <tr>s above this. So, particular page is returning 5 <tr>s and they all have this same behavior.

Thanks,
Tim

$q6 = "SELECT id, delivery_value from i6delivery_type where task_type_id = $row4->task_type";
$result6 = mysql_query($q6,$i6link) or die (mysql_error());
$row6 = mysql_fetch_object($result6);
echo"
<td align=left>
<select name=\"i6f[task_delivery_type$row4->task_type]\">
<option selected value=\"$row4->delivery_type\">$row4->delivery_type</option>
";
while ($row6 = mysql_fetch_object($result6)) {
echo"
<option value=\"$row6->delivery_value\">$row6->delivery_value</option>
";
}
echo"
</select>
</td>";

[kevinsequeira]

comment this line
$row6 = mysql_fetch_object($result6);

to

// $row6 = mysql_fetch_object($result6);

it will work, whats happenning is uve already gone to the first row outside the while loop, and so in the while loop ure actually starting from the second row

reg
kevin

[thines]

Thanks Kevin,

Sorry for the easy oversight.

-Tim