In message <[EMAIL PROTECTED]>, Wade <[EMAIL PROTECTED]>
writes
>
>04132005 1355 GMT-6
>
>I should know this but I find I do not.
>
>I want to get the total number of records in a certain table.
>
>Would I do something like
>  select * from x

SELECT COUNT(*) AS totalrecords FROM x 
is much more efficient


-- 
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/
 



Reply via email to