RE: [PHP] return the amount of records in a mysql databace
| From: | John Holmes | Date: | Mon, 23 Sep 2002 01:28:19 +0000 |
| Subject: | RE: [PHP] return the amount of records in a mysql databace | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-117218@lists.php.net to get a copy of this message | ||
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:jeff@domintcom.com]
> Sent: Sunday, September 22, 2002 11:46 AM
> To: php-general@lists.php.net
> 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: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 ?
> >
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php