syntax trouble

[jcook]

I am trying to query the entire database and retrieve all the information in it so I can print it on the screen.... I know how to print it but I do not no the syntax for the query....

[mourisj]

$list = mysql_list_tables(db_name);

while ($i < mysql_num_rows($list))
{
$name = mysql_tablename($list, $i);

$content = "select * from $name";

$rows = mysql_query($content);

while ($line = mysql_fetch_array($rows))
{
// echo the data here
}

}

JJ Mouris

[jcook]

thank you kindly

[jcook]

hey is $i supposed to equal something in the beginning and then be raised every time it loops??????

[mourisj]

Hello,

You are right, you have to do $i = 0; before the first while-loop.

I overlooked this one.

Also note that I didn't test all the code. I quickly gathered the snippets from code I wrote which enables me to manage any table of a database as far as the first column of each table is at least defined as INT and the values are UNIQUE.

Have a nice day,

JJ Mouris