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]
