create dropdown menu from returned $result
| From: | PAUL FERRIE | Date: | Sun, 16 Nov 2003 16:24:36 +0000 |
| Subject: | create dropdown menu from returned $result | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-169842@lists.php.net to get a copy of this message | ||
What am i overlooking?
<?
include('common.php');
$result = mysql_list_tables("***_vinrev");
$i = 0;
while ($i < mysql_num_rows ($result)) {
$tb_names[$i]= mysql_tablename ($result, $i);
echo "<SELECT NAME='$tablename'>";
echo "<OPTION VALUE=\"".$tb_names[$i]."\">".
$tb_names[$i]." </OPTION> ";
echo $tb_names[$i] . "<BR>";
$i++;
}
echo "</SELECT>";
?>
When tested
heres what i get
http://thor.ancilenetworks.co.uk/~pferrie/vinrev/adm/table_list.php
There are 2 tables within the DB 'reviews', 'albums'
Cheers
Paul