Re: count
| From: | Mike | Date: | Thu, 11 Apr 2002 11:03:56 +0000 |
| Subject: | Re: count | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18426@lists.php.net to get a copy of this message | ||
Sorry, That's not right. This is what I really meant to say.
SELECT COUNT(column) as somename FROM table;
or
Select count(ID) name from $table;
Mike
----- Original Message -----
From: "Allen, Ronald L CIV" <allenr@FWD.AREUR.ARMY.MIL>
To: "Mike" <mike@wkla.com>
Sent: Thursday, April 11, 2002 6:52 AM
Subject: RE: [PHP-DB] count
> Something like this
> Select sum(ID) name from $table;
>
> Where name is some name that I come up with?
>
> >Ronald L. Allen (MCSE NT, MCP, CCNA)
> SR. LAN/WAN Administrator
> >SFOR - Hungary, Croatia
> >allenr@fwd.areur.army.mil
> >ronallen@techie.com
> >+36-82-500000 ext. 22580
> > DSN: 760-2000
>
>
> -----Original Message-----
> From: Mike [mailto:mike@wkla.com]
> Sent: Thursday, April 11, 2002 12:54
> To: Ron Allen
> Cc: php-db list
> Subject: Re: [PHP-DB] count
>
>
> SELECT SUM(column) as somename FROM table;
>
> Mike
> ----- Original Message -----
> From: "Ron Allen" <allenr@fwd.areur.army.mil>
> To: <php-db@lists.php.net>
> Sent: Thursday, April 11, 2002 6:52 AM
> Subject: [PHP-DB] count
>
>
> > I would like to count all the total records from a database. How
> > would I
> go
> > about doing that???
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02