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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



the quickest solution and one that is easy to understand, I am no php expert and have never claimed as such so why 'noob'?

Why is this such a poor method? if i type the HTML to be outputted correctly then what validation is required? also I think Someone new would run from your proposed solution

Jochem Maas wrote:

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



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux