[RESOLVED] Start to load drop down menu from 2nd row of table

[Techissue2008]

Hi

I have the following dynamic drop down menu. The id value for the first row is '0'.

However, I want to start the drop down from '1', not display '0'.

How can I do that?

<select name="productid">
$query = "select productid, product from product ";
$result = mysql_query($query) or die('Error : ' . mysql_error());
while($arrayRow = mysql_fetch_assoc($result)) {
$intIdField = $arrayRow['productid'];  //how can it be started from '1' / 2nd row
$strNameField = $arrayRow['product'];
echo "<option value=\"$intIdField\">$strNameField</option>\n";		
}
echo "</select>\n\n";				 
?>

Thanks for help.

[Techissue2008]

anyone could help?

[bodzan]

Quick and dirty solution, if you happen to know the product id you want to avoid, would be something like:

<select name="productid">
$query = "select productid, product from product ";
$result = mysql_query($query) or die('Error : ' . mysql_error());
while($arrayRow = mysql_fetch_assoc($result)) {
if($arrayRow['productid']!="0"){//or whatever id is it you want to avoid
    $intIdField = $arrayRow['productid'];  //how can it be started from '1' / 2nd row
    $strNameField = $arrayRow['product'];
    echo "<option value=\"$intIdField\">$strNameField</option>\n";		
}
}
echo "</select>\n\n";

Of course, if this won't help your case it would be a good idea to tell us WHY you would want to avoid the particular row...

[Techissue2008]

It does work, thank you very much.

The reason to avoid the first row as it is a "Select All" option. However, I cannot let user input "Select All" as the value to table. It must be the value starting from 2nd row.