Thanks for the quick response, but I'm still having a bit of difficulty with

I'll go into a bit more detail:

I have my database and what I need in the dropdown is the results of a query
on the field unit_tag in a table named unit_name.
I see how the code snippet creates the dropdown box but I'm still fuzzy on
how to pass the query results.

----- Original Message -----
From: "Richard Hillström (GIS)" <[EMAIL PROTECTED]>
To: "'Mark C. Farrington'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 9:31 AM
Subject: RE: [PHP-DB] Converting MySOL query results into form elements.

> I solved it like this:
> echo "<SELECT NAME='databasename'>";
>         while($row = sybase_fetch_array($dbresult)) {
>                 $r0 = $row[0];
>                 echo "<OPTION VALUE='$r0'>$r0</OPTION>";
>         }
> echo "</SELECT><BR>";
> //Richard
> -----Original Message-----
> From: Mark C. Farrington [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 29, 2001 3:25 PM
> Subject: [PHP-DB] Converting MySOL query results into form elements.
> What I need to do is query a MySQL db and turn the results into a dropdown
box on a form.
> I've been paging through my books and I've come accross the command
writeOptionList which seems to be what I'm looking for but I'm not sure how
to use it.
> Self taught programming is a joy eh?
> Mark C. Farrington

PHP Database Mailing List (
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