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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]