Looping through another looping

[ausge]

I made a drop down menu and am trying to edit it but it only loops 1 times

<?php 
do{?>
<tr>
 <td>

<select name="unit[]" id="unit">
                                                <option value="0">select</option>
<?php 
do{?>
                                                    <option value="<?php echo $row_container_unit['id'];?>" 
<?php if($row_container_unit['id']==$row_inland_operation['id'])            {?>selected='selected'<?php }?>>

<?php echo substr($row_container_unit['name'],0,20);?>                    </option>
<?php }while($row_container_unit = mysql_fetch_assoc($container_unit));?>
</select>
 </td>
</tr>
 <?php }while($row_inland_operation=mysql_fetch_assoc($inland_operation));?>

So its only giving me the first value
but it doesn't show me the rest
any help????

[Dan Grossman]

Are $container_unit and $inland_operation assigned to valid result resources with unfetched rows in them?

[ausge]

am using those statements at the top:

$query_container_unit="select * from container_unit";
$container_unit = mysql_query($query_container_unit) or die(mysql_error());
$row_container_unit= mysql_fetch_assoc($container_unit);

$query_inland_operation="select * from inland_operation inl , container_unit cn where oper_id='".$operation_id."' and inl.unit=cn.id";
$inland_operation = mysql_query($query_inland_operation) or die(mysql_error());
$row_inland_operation= mysql_fetch_assoc($inland_operation); 

[ausge]

what am thinking
that we cant use the do while statement with the same name more than once right??

but how can i loop through the options again??

[Cups]

Take a look at mysql_data_seek, resets the pointer of a result set to the beginning so you can reuse it on the same script.

[ausge]

Oh thank you
i put mysql_data_seek($result, 0);
an the end of my inside loop
and it works fine now
Thankss again