]
To: DL Neil [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 24 January 2002 00:01
Subject: RE: [PHP-DB] # of Records in Table
There are many columns of data in the table. The only column that I would
like to extract a value from is the password field (this is the key as
well). I do not have
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
does the table have an autoincrement column?
Jim Lucas
- Original Message -
From: Zach Curtis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
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
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 1:11 PM
To: Zach Curtis; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] # of Records in Table
Zach,
What syntax can I use to determine how many records are in a MySQL table
and
then retrieve the value
20:49
Subject: RE: [PHP-DB] # of Records in Table
The last record should be whatever the last record is in the table. For
example, if there are 1000 records in the table which COUNT(*) will tell me,
how can I get the password for record 1000. The only thing I can do that
would probably work
SELECT * FROM mytable ORDER BY fielda DESC LIMIT 1;
- Original Message -
From: Zach Curtis [EMAIL PROTECTED]
To: DL Neil [EMAIL PROTECTED]
Sent: 23 January 2002 20:49
Subject: RE: [PHP-DB] # of Records in Table
The last record should be whatever the last record is in the table
January 2002 20:49
Subject: RE: [PHP-DB] # of Records in Table
The last record should be whatever the last record is in the table. For
example, if there are 1000 records in the table which COUNT(*) will tell
me,
how can I get the password for record 1000. The only thing I can do that
would
Excellent. That is more efficient (one select statement) than what I was
trying to do.
Zach
-Original Message-
From: Miles Thompson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 2:20 PM
To: Zach Curtis; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] # of Records in Table
is going to give their (free) time to help you out. (grumble)
=dn
- Original Message -
From: Zach Curtis [EMAIL PROTECTED]
To: DL Neil [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 23 January 2002 21:52
Subject: RE: [PHP-DB] # of Records in Table
The key field is the password field, which
[EMAIL PROTECTED]
Sent: 23 January 2002 20:49
Subject: RE: [PHP-DB] # of Records in Table
The last record should be whatever the last record is in the table. For
example, if there are 1000 records in the table which COUNT(*) will tell
me,
how can I get the password for record 1000. The only
: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] # of Records in Table
Zach,
We're going back and forth on this and getting no where...
So far all you have informed us is that the table has one column, which
contains a bunch of passwords (I also
suggest that this is not really the case and there'll
are worth it.
---Original Message---
From: Zach Curtis
Date: Thursday, 24
January 2002 1:02:07 p.
To: DL Neil
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] #
of Records in Table
There are many columns of data in the table
12 matches
Mail list logo