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