In article <[EMAIL PROTECTED]>, 
> 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
> > 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 (
To unsubscribe, visit:

Reply via email to