In message <[EMAIL PROTECTED]>, Wade <[EMAIL PROTECTED]> writes > >04142005 1044 GMT-6 > >Sorry, didnt make myself clear. > I need to know how many total records are in a single table. > > So, > $sql = "SELECT COUNT(*) AS totalrecords FROM application"; > $result=mysql_query($sql, $connection);
totalrecords can now be treated like an 'ordinary field'. What do you *usually* do next? I usually do list($total)=mysql_fetch_array($result) but you could treat it as you treat any other field returned in a query. -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
