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);
???
Wade
Pete wrote:
> 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]
> <mailto:[EMAIL PROTECTED]>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
>------------------------------------------------------------------------
>
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.308 / Virus Database: 266.9.8 - Release Date: 4/13/2005
>
>
[Non-text portions of this message have been removed]
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/
