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>";


-----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 

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]

Reply via email to