Re: return the amount of records in a mysql databace

Look through the MySQL functions. I seem to recall that there is a function for just about anything, and all you really want to do is find how many rows are in all the tables in a particular database. Thus, a couple of loops is all you need, with the outer one looping through each table (obtained from a function) and the inner one doing a select count(*) or a mysql_num_rows(). Happy hacking. Chris Jeff Bluemel wrote:

this is only going to return records in a table, and not in a database

select count(*) as n from ... where ... -----Original Message----- From: Philip J. Newman [mailto:newmanpj@philipnz.com] Can someone point me in the right direction to find out how i can return

the

amount of records in a mysql databace ?