Hi gang this is probably ridicously simple, but I'm new at this SQL stuff, so am a bit stumped. It's pretty simple: how do I get only the last record from a single table? Trying to convert my file-based website into DB-based, but can't quite figure out how to do this simple task. Table name is history, and only have 3 fields: histID, date, entry I need it to pick the last record without knowing the date of it. Got picking specific records down good, but be damned if I can figure this one out... TIA Rene Rene Brehmer aka Metalbunny http://metalbunny.net/ References, tools, and other useful stuff... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php