Have you tried any diagnostic to find out what fields are being returned by
the query, something like:
If ($result = mysql_query("show tables"))
{       while ($row = mysql_fetch_array($result))
{       foreach($row as $fieldname=>$value) echo("$fieldname=>$value<br>");

I think you'll find the field you want is something like "Tables_in_dbname".

Tim Ward
www.chessish.com <http://www.chessish.com> 

        From:  Ron Clark [SMTP:[EMAIL PROTECTED]]
        Sent:  26 February 2002 21:02
        To:  [EMAIL PROTECTED]
        Subject:  Help with showing tables in DB

        -----BEGIN PGP SIGNED MESSAGE-----
        Hash: SHA1

        Consider the following:

            $result = mysql_query("show tables");
            while ($rows = mysql_fetch_object($result)) {
                echo $rows;

        So why does this not return the Table names? I have even tried "echo
        rows->Table" and "echo rows->Tables" to no avail. So how do I fix
        Thanks in advance,
        Ron C.

        -----BEGIN PGP SIGNATURE-----
        Version: PGP 7.1

        -----END PGP SIGNATURE-----


PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to