Re: Is there a way to display data from database for Select Options in a form?

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