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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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)" <[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 > > To: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- 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]