Hi,

I'm using PHP 4.4.4 with MySQL 5.0. Given my db connection info, how
would I figure out how many tables were in the selected db?

Thanks, - Dave

laredotornado [at] zipmail.com wrote:
> Hi,
>
> I'm using PHP 4.4.4 with MySQL 5.0. Given my db connection info, how
> would I figure out how many tables were in the selected db?

http:/www.php.net/manual/en/function.mysql-list-tables.php

--

//Aho

laredotornado [at] zipmail.com wrote:
> Hi,
>
> I'm using PHP 4.4.4 with MySQL 5.0. Given my db connection info, how
> would I figure out how many tables were in the selected db?
>
> Thanks, - Dave
>

One way, maybe others that are better?

<?php
mysql_connect("localhost", "<user>", "<pass>");
mysql_select_db("<database>");
$sql = "SHOW TABLES;";
$ds = mysql_query( $sql );
echo mysql_num_rows( $ds );
mysql_free_result( $ds );
?>

<laredotornado [at] zipmail.com> wrote in message
news:1179179200.148304.182970 [at] p77g2000hsh.googlegroups.com.. .
> Hi,
>
> I'm using PHP 4.4.4 with MySQL 5.0. Given my db connection info, how
> would I figure out how many tables were in the selected db?
>
> Thanks, - Dave
>

With MySQL I think you can run a query like "show tables;" and should be
able to get a count from those results.

Tom
--
Newsguy.com - Express Accounts - 30 GB $9.95 / month