Mysql/php _list_tables question

I would like to extract just one table from the database. Here is the code I am using. Works but it pulls out every single table I have. Is there a way to just pull out one specified table?

[php]
function ddtables ($dbname){
if (!empty($dbname)) {
$result = mysql_list_tables($dbname);
$i = 0;
echo "\nTables: onChange=\"JavaScript:form.submit();\">\n";
echo "select table ....\n";
while ($i < mysql_num_rows ($result)) {
$tb_names[$i] = mysql_tablename ($result, $i);
echo "
$tb_names[$i]\n";
$i++;
}
echo "";
}
}
[/php]

Let me get this straight: You want to create a drop down list of all the tables in your mySQL database? If so, that code will work. I'm a little confused.

No, it's a drop down right now with all of them. What I would like is just "one" specified table to show up in the drop down...

Yes, everything does work right now. I just want to change it to limit access to only one table. Right now all 25 or so show up and I only need to view one in the drop down.

Well, the easiest way would be to put an if statement inside the while loop. If $tb_names[$i] equals the name of the table you want to show, echo it; otherwise, add 1 to $i and go through the loop again. To save processing time after the table name has been echoed, put a break; inside the if statement. HTH!

I'll try it out. Thanks.

I thought there may be an actual Mysql command I was missing to display just one table like the list_tables function.

Nope, don't think any function like that exists. The best way though is to loop up list_tables() in the PHP function reference at http://www.php.net and look for similar functions that it suggests in the left column. Very helpful at times.