Deleted code by accident...help?

Ok, i did have this code that counted all the enrties in the MYSQL database accross all the tables.

The code was on the "Home Page" and said:

"The database currently holds (***) images."

*** being the php code to work out the number of pics.

Could someone help me out, as i really cant remember how it was done.

Many thanks.

info

The database has about 8 or so tables, each table contains about 100 or so image paths.

phpmyadmin, has a SUM when you select the main DB, that is the figure that i want.

I have this code, that looks throught just ONE table....

could anyone show me how to addapt it to search all the tables.

$query = mysql_query ( "SELECT COUNT(*) AS number FROM mytable") ;
list($count) = mysql_fetch_array($query);
echo " <b> $count </b>";

Um... run the query on each table and add all the counters up...?

yes, i did think of doing that...... but before i had reasonably simple code that did not add together each of the tables, it did it another way.

I dont want to do it like that, because im always changing tables and adding tables, so ill always have to change the code.

Im sure there is a easy way to do this.

can someone help~?

Just a shot in the dark,....

Would this work as your SQL query? (dunno here, just guessing)

SELECT COUNT(*) AS number FROM table1,table2,table3,table4,table5,table6,table7,table8;

Correction:
This wont work, my bad. It will return the combination of the tables (COUNT COUNT COUNT ....n)

You could use SHOW TABLES or SHOW TABLE STATUS to get a list of tablenames... then loop through that...

Mabye a JOIN?

superwormy is right, you need a counter. There is no variable that keeps track of all table entries in a db.
The concept is pretty simple:

Extract the number of tables in your db, along with their names.
Initialize counter.
For each table, use the code
$query = mysql_query ( "SELECT COUNT(*) AS number FROM mytable") ;
list($count) = mysql_fetch_array($query);
set counter += counter

That's it.

HTH

ok guys thanks, Im sure the code that my dumb ass deleted was simpler, but ill go with your method.

One thing though............im mot the best at programming.
if i do a mock one here for two tables...

"images1" and "images2"

$query = mysql_query ( "SELECT COUNT(*) AS number FROM images1") ; 
list($count) = mysql_fetch_array($query);

i dont know what to do with the counter when i get to here.?

set counter += counter ?????

thanks for your help,

here is the link to the earlier code

reg
kevin