on 4/26/01 11:16 AM, ns ([EMAIL PROTECTED]) wrote:

> hi
> i got to have data from mysql database to drop down menues in html how do i
> do that?
> I canīt get any data to my drop down menues...

You need to run a query, something like:

SELECT DISTINCT from TABLE where SOMETHING

and they run a while loop to drop the values into a select field, i.e.,

echo '<option value="' , $row['fieldname'] , '">' , $row['fieldname'] ,
'</option>';

You may want to check out a small script I wrote:

<http://webdevel.burney.ws/code/id?14>

Hope that helps,

Paul Burney

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Paul Burney
Webmaster and Open Source Developer
Educational Technology Unit
Graduate School of Education and Information Studies
University of California, Los Angeles
(310) 825-8365
<[EMAIL PROTECTED]>
<http://www.gseis.ucla.edu/>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to