well this is my problem!

<?php
$host = "*****";
$user = "*****";
$pass = "*****";
$link = mysql_pconnect($host, $user, $pass);
$db_list = mysql_list_dbs( $link );
while ($row = mysql_fetch_object( $db_list ))
echo $row->Database;
mysql_close($link);
?>

okej thats nice... now to output?

------------------------------
test
------------------------------

Argh -hmm I have like 30 databases hmmm hmm... HELP

Firstly I don't think you want to be using a permanent connection, which is created in the line:

$link = mysql_pconnect($host, $user, $pass);

I'm assuming this because your trying to close the connection with mysql_close, and this is not possible when you've made a permanent connection. Use mysql_connect instead.

After that I'm a bit lost on what you want to do? Do you want to retrieve the data in all databases ?

Well you could store the names of your databases into an array i.e
$dbnames[] = $row->Database;

You could then perform a select query on each of the databases:
foreach ($dbnames As $dbname) {
$result = msql_query("SELECT * FROM $dbname");
while($tmp = mysql_fetch_row($result))
dump data
}

For a more elequent way to retrieve the data from a mysql_fetch_row, check out the comments at: http://uk.php.net/manual/en/function...-fetch-row.php.

Hope this helps.

Added later:

I was thinking of mysql_fetch_array($result, MYSQL_NUM) syntax rather than mysql_fetch_row.

There's a glaring typo (or two) in your example code; so your first attempt should be to fix that...

__________________
J de Silva
Learning Journal | GIDForums™ | GIDNetwork™ | GIDWebhosts™ | GIDSearch™

Sorry JdS..
but there is nothing wrong with that code

http://www.php.net/manual/en/control...ures.while.php
not using the curcly braces only 'executes' one following statement

__________________
Pastebin
PHP Documentation Site
Allowee's Blog http://allowee.net

If the code inside a while loop, if statement, for loop etc... is a one liner, then that code will run as far as i'm aware?

Yes, I realised that as soon as I was redirected to the thread; since the message went in an email; I said f'it!

This is why I SHOULD refrain from replying to code issues when I am rushing

__________________
J de Silva
Learning Journal | GIDForums™ | GIDNetwork™ | GIDWebhosts™ | GIDSearch™