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" <[EMAIL PROTECTED]> To: "Mike" <[EMAIL PROTECTED]> 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 > >[EMAIL PROTECTED] > >[EMAIL PROTECTED] > >+36-82-500000 ext. 22580 > > DSN: 760-2000 > > > -----Original Message----- > From: Mike [mailto:[EMAIL PROTECTED]] > 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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php