[Space_kadett]

I'm making a dropdown list populated with all productnames from a pricelist (table), where users can select a product, and hit the button to proceed to a page that displays product details and price.
Works like a charm - except for ONE small problem: the first product in the table doesn't appear on the dropdown list, it starts out with a empty line.
If you select the empty line, you get a
-You have an error in your SQL syntax near '' at line 1- message on the next page, all the others work perfect....
I'm confused here - can anyone help??

PHP Code:

<?php

//connect

$db = mysql_connect("host", "user", "password");



mysql_select_db("database", $db);

// We have now connected, unless you got an error message 



//get ID and item from table

$query_art = "SELECT ID, art FROM prices";

$art = mysql_query($query_art) or die(mysql_error());

$row_art = mysql_fetch_row($art);

?>



<!--sends ID from selected item to display.php-->



<form name="form" method="post" action="display.php">

  

   <select name="fieldOne">

    <option value="">Velg artikkel</option>

    

<?php

//insert item into dropdown with ID as value

do 

    {  

?>



    <option value="<?php echo $row_art['ID']?>"><?php echo $row_art['art']?></option>

<?php

    } 

while ($row_art = mysql_fetch_assoc($art));

?>

  </select>

          

    <input type="submit" name="Submit" value="Finn prisen" >



</form>

[Space_kadett]

Ok, so you couldn't solve it either...

Well, I "hid" the problem by adding a empty row to the table and sort by art to the query, so now it LOOKS right..............

:-)

[Mickey1984]

you can try my code:
<?php
while($row_art = mysql_fetch_row($art))
{
?>
<option value="<?php echo $row_art['ID']?>"><?php echo $row_art['art']?></option>

<?php
}
?>
the problem may be the do^while,because when you run the code first time,the $row_art doesn't konw the exact result if the table prices has too many recorde!!(I hope you can understande my mean ,my english is very poor,English is not my native language)
and i think Space_kadett's way is not bad!

[darkfreak]

Originally Posted by Space_kadett

PHP Code:

<?php

//insert item into dropdown with ID as value

do 

    {  

?>



    <option value="<?php echo $row_art['ID']?>"><?php echo $row_art['art']?></option>

<?php

    } 

while ($row_art = mysql_fetch_assoc($art));

?>

  </select>

          

    <input type="submit" name="Submit" value="Finn prisen" >



</form>

Wouldn't it help if you just turn the loop upside down - now that you have the DO before WHILE you apparently don't have any value in $row_art['ID'] at the first round. Try to do it something like:

PHP Code:

<?php

while( $row_art = mysql_fetch_assoc($art) ) {



        echo "<option value=$row_art[ID]>$row_art[art]</option>\n";



} // end of while

?>