Hi!

When I try to execute the script below from my company's intranet server, I get a white screen. When I run it on a different web server, it works. Does anyone know why this might be? Is it a "port" that I need to open?

I'm also using PHP5 and MySQL 4.1.13a-nt (I think) on the server where I'm having the problem.

It's working on my personal website's server with PHP 4.3.11 and MySQL 4.0.25 standard.

Here's the script. Thanks in advance!! Josh
----------------------------
<?php
//list_db.php

$link_id = mysql_connect("localhost", "phpuser", "phppass");
$result = mysql_list_dbs($link_id);
$num_rows = mysql_num_rows($result);

while($db_data = mysql_fetch_row($result)) {
        echo $db_data[0]. "<BR>";
        $result2 = mysql_list_tables($db_data[0]);
        $num_rows2 = mysql_num_rows($result2);
        while($table_data = mysql_fetch_row($result2)) echo "--" . $table_data[0]. "<BR>";
        echo "==> $num_rows2 table(s) in " . $db_data[0] . "<P>";
}
?>



Josh Gilliam
[email protected]

I recommend you using mysql_fetch_array() lieu mysql_fetch_row().

To know about errors, just use ini_set('display_errors', '1'); in top of code.

`~@#\^%&*/\.<.\/-|+|_!:;..=?>
Support Indian students' finances http://scholarship.mediasworks.com/

Josh,
On your personal server you are using 3.23/4.0 mysql version.
The password field number of characters on the old version is 16 byte compared
to 4.1 mysql version of 39/40 byte. When connecting to a mysql database,
your password is always encrypted to the number to bytes for that mySql server. Try on your new version 'localhost', 'root', ''. This is the administrator's default. When you are connected, delete and create your old username and password.
John