₦airaland Forum

hello,
i want to echo out the tables in a database, my code is:

mysql_connect("localhost", "tables", "" or die(mysql_error());
echo "connected to database";

mysql_select_db("today" or die(mysql_error());
echo "Connected to database<br>";
$tables=mysql_list_tables("today";

if ($tables ==""{
echo "this database does not have a table";
exit;
}else {
echo $tables;
}

the result i am getting is

connected to database

Connected to database

Resource id #3
the last line is the problem, please can anyone help me sort out what the problem is?
i am using phpmyadmin to connect php to mysql.
pleasee

$tables=mysql_list_tables("today";

The function mysql_list_tables returns a resource identifier to the result. And that is why you are getting what you are getting. You still need a couple of code lines to draw up the resource result.
Here:

,
$tables=mysql_list_tables("today";
while(list($tbl) = mysql_fetch_array($tables)){
echo $tbl;
}
,

I didnt test that (stole just some minutes to come around NL) but I hope it works.

*** I think i need some sleep before these guys scatter my head with codes, DHTML yawns and fell asleep dreaming of php & mysql

been long i seen u here kehers, whats happening?

@webdezzi
Been busy wt a lot of sku work and hardly come online ds days. Hopefully, I will b fully back real soon

no problem, we see wen we see