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
Quod subigo farinam
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php