Re: # of Records in Table
| From: | Zach Curtis | Date: | Wed, 23 Jan 2002 20:52:12 +0000 |
| Subject: | Re: # of Records in Table | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16117@lists.php.net to get a copy of this message | ||
It does not. However, I could easily add this in if you have a suggestion
that would work. Ideally, I thought their would be a way to do this
operation in one select statement. Any thoughts?
Zach
-----Original Message-----
From: Jim Lucas [php] [mailto:jimphp@bend.com]
Sent: Wednesday, January 23, 2002 1:10 PM
To: Zach Curtis; php-db@lists.php.net
Subject: Re: [PHP-DB] # of Records in Table
does the table have an autoincrement column?
Jim Lucas
----- Original Message -----
From: "Zach Curtis" <zach@populus.com>
To: <php-db@lists.php.net>
Sent: Wednesday, January 23, 2002 10:27 AM
Subject: [PHP-DB] # of Records in Table
> 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.
>
> Thanks.
>
>
> Zach Curtis
> POPULUS
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>