create dropdown menu from returned $result

[-__webdreamer__]

What am i overlooking?

<?
include('connection.php');
$result = mysql_list_tables("pferrie_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
table list

There are 2 tables within the DB 'reviews', 'albums'

Cheers
Paul

[LordShryku]

Looks like it works fine. What's the problem?

[-__webdreamer__]

WDF

It works 🙂

Strange

[-__webdreamer__]

Is there a way of tracing the variable $tablename to see if it has been set with the table name from the drop down menu?

Cheers

PHP+Flash 🙂
php+HTML 🙁