Posted by Jochem Maas on 01/10/06 18:37

teaching noobs to output html while (oun intended) looping thru a
result set is counter-productive. discuss.

Adrian Bruce wrote:
> 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
>>
>>
>

[Back to original message]