cancel this, found my problem :) this query worked: SELECT * FROM subscribers ORDER BY acctid DESC LIMIT 1
-------- Original Message -------- Subject: Query last record in table Date: Mon, 05 Jul 2004 13:52:28 -0500 From: Mike Blezien <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Organization: Thunder Rain Internet Publishing To: MySQL List <[EMAIL PROTECTED]>
Hello,
what is the most effecient way to query the last record in a table, if querying the primary key(acctid) column ??
I've tried "select *,max(acctid) as lastid from subscribers where acctid = 'lastid' group by acctid" but this returns nothing ??
TIA :)
-- Mike<mickalo>Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://thunder-rain.com =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
