Posted by Adrian Bruce on 01/10/06 18:26

Something along these lines will work fine

<?php
$query = mysql_query("select dates from table ") or die (mysql_error());

echo"<select name='test'>";

while ($row = mysql_fetch_array($query, MYSQL_NUM)){

echo"<option value='$row[0]'>$row[1]</option>";

}
echo"</select>";
?>

Regards
Ade

Sue wrote:

>Hello,
>
>We have a form that contains a Select option for a listing of available
>dates for the user to choose from. Right now we have to manually change the
>dates within the form's Selection list as new dates become available to
>choose from. We currently store these available dates in our database, and
>am wondering if we can somehow extract these dates from the table to display
>in our form? This would eliminate alot of maintenance needed to this form.
>If anyone has any ideas as to reference material etc. that I may look which
>would give me an idea how to do this using PHP, I'd appreciate it!
>
>Thanks!
>Sue
>
>
>

• Next in forum: Re: [PHP] Is there a way to display data from database for Select Options in a form?
• Prev in forum: Is there a way to display data from database for Select Options in a form?
• Thread view: Re: [PHP] Is there a way to display data from database for Select Options in a form?

[Reply to this message]