In article <[EMAIL PROTECTED]>, 
[EMAIL PROTECTED] says...
> I know how to get the results for the total number of records
> select count(*) from $table
> but how do I put them into a variable for me to use later???
> 
> "David Robley" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > In article <[EMAIL PROTECTED]>,
> > [EMAIL PROTECTED] says...
> > > I would like to count all the total records from a database.  How would
> I go
> > > about doing that???
> >
> > Do a COUNT * on each table and total the results? Although the results
> > may actually not mean much depending on your DB structure. Or do you
> > really mean count records in a _table_?


Aliases. SELECT COUNT(*) AS howmany FROM table

Then use the variable $howmany

-- 
David Robley
Temporary Kiwi!

Quod subigo farinam

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to