select count(*) as n from ... where ... This worked well for me.
----- Original Message ----- From: "John Holmes" <[EMAIL PROTECTED]> To: "'Jeff Bluemel'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, September 23, 2002 1:28 PM Subject: RE: [PHP] return the amount of records in a mysql databace > 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 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
