MySQL Tables Array?

How to get all tables into an Array...

[ahmedtheking]

Is it possible to run such a query:

SHOW TABLES

In php, via mysql_query and get the tables as an array?

The purpose of this is so that I can run the same query on seperate tables without having to rewrite the query for each table!

[anshul]

SHOW TABLES is perhaps an exception to mysql_query()
SHOW DATABASES, but works.
U may c PHPMyAdmin, if u've ( code ); how its lists tables!

[ahmedtheking]

But is there a way to stick the table names into an array?

[coopster]

You can get any data back from a mysql_query you want. The easiest way to find out what is coming back and how it comes back is to dump the $row returned array.

<pre> 
<?php 
$rows = mysql_query("SHOW TABLES FROM test"); 
while ($row = mysql_fetch_assoc($rows)) { 
print_r($row); 
} 
?> 
</pre>

So, knowing what is coming back, you design your query ...

<pre> 
<?php 
$tables = array(); 
$rows = mysql_query("SHOW TABLES FROM test"); 
while ($row = mysql_fetch_array($rows)) { 
$tables[] = $row[0]; 
} 
print_r($tables); 
?> 
</pre>

[anshul]

> You can get any data back from a mysql_query you want.

It is sometimes useful to get all information on a Web page, as given at [U]command prompt[/U] by MySQL daemon.
Like '5 records updated', '1 row inserted', 'not found', 'query took 0.018 sec' etc. Can? someone tell to get this all infomation in PHP.

[ahmedtheking]

Ah nice one, I'll give that a try!

[Stormfx]

anshul

Try:

[php.net...]

&

[php.net...]