RE: [PHP-DB] Converting MySOL query results into form elements.
| From: | GIS) | Date: | Thu, 29 Nov 2001 14:31:00 +0000 |
| Subject: | RE: [PHP-DB] Converting MySOL query results into form elements. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14690@lists.php.net to get a copy of this message | ||
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