Re: # of Records in Table
| From: | DL Neil | Date: | Wed, 23 Jan 2002 20:11:15 +0000 |
| Subject: | Re: # of Records in Table | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16113@lists.php.net to get a copy of this message | ||
Zach,
> What syntax can I use to determine how many records are in a MySQL table and
> then retrieve the value of the field "password" for the last record? I tried
> using some combinations of COUNT(*) and LIMIT with no success.
SELECT COUNT(*) will answer the first part. What did you try that lacked success?
How do you define "last record"? We might need to see the table definition to answer this.
Regards,
=dn