Re: return the amount of records in a mysql databace
| From: | Philip J. Newman | Date: | Mon, 23 Sep 2002 01:45:36 +0000 |
| Subject: | Re: return the amount of records in a mysql databace | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-117223@lists.php.net to get a copy of this message | ||
select count(*) as n from ... where ...
This worked well for me.
----- Original Message -----
From: "John Holmes" <holmes072000@charter.net>
To: "'Jeff Bluemel'" <jeff@domintcom.com>;
<php-general@lists.php.net>
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: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
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>