Re: Converting MySOL query results into form elements.
| From: | Mark C. Farrington | Date: | Thu, 29 Nov 2001 17:30:24 +0000 |
| Subject: | Re: Converting MySOL query results into form elements. | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-14699@lists.php.net to get a copy of this message | ||
Ok, the answer was staring me in the face. I have it all figured out now.
Thanks for the help.
----- Original Message -----
From: "Mark C. Farrington" <alareth@earthlink.net>
To: <php-db@lists.php.net>
Sent: Thursday, November 29, 2001 11:59 AM
Subject: Re: [PHP-DB] Converting MySOL query results into form elements.
> Thanks for the quick response, but I'm still having a bit of difficulty
with
> it.
>
> 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)" <Richard.Hillstrom@gis.ericsson.se>
> To: "'Mark C. Farrington'" <alareth@earthlink.net>;
> <php-db@lists.php.net>
> 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:alareth@earthlink.net]
> > Sent: Thursday, November 29, 2001 3:25 PM
> > To: php-db@lists.php.net
> > 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 (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>