Then do a SHOW DATABASES query before that and loop through the results, counting the rows in each table.
If you have to do this, though, I think you have some normalization issues with your database... ---John Holmes... > -----Original Message----- > From: Jeff Bluemel [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 22, 2002 11:46 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP] return the amount of records in a mysql databace > > 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:[EMAIL PROTECTED]] > > > > Can someone point me in the right direction to find out how i can return > the > > amount of records in a mysql databace ? > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
