These two work fine: SELECT * FROM ggSubmissions,ggSubEx WHERE ggSubmissions.GGsID != '1673' AND ggSubmissions.GGsID = ggSubEx.GGsID AND ggEID=51 AND WorkTitle > "Aerial - Manly Beach Surfers 1 - Sydney, Australia, February 2003" ORDER BY WorkTitle ASC LIMIT 1
SELECT * FROM ggSubmissions,ggSubEx WHERE ggSubmissions.GGsID != '1674' AND ggSubmissions.GGsID = ggSubEx.GGsID AND ggEID=51 AND WorkTitle > "Aerial - Manly Beach Surfers 2 - Sydney, Australia, February 2003" ORDER BY WorkTitle ASC LIMIT 1 But these don't work -- the second passes back to the first instead of continuing in alphabetical order: SELECT * FROM ggSubmissions,ggSubEx WHERE ggSubmissions.GGsID != '1686' AND ggSubmissions.GGsID = ggSubEx.GGsID AND ggEID=51 AND WorkTitle > "Airborne - Shepherd\'s Warning 1 - Pacific Ocean, December 2002" ORDER BY WorkTitle ASC LIMIT 1 SELECT * FROM ggSubmissions,ggSubEx WHERE ggSubmissions.GGsID != '1687' AND ggSubmissions.GGsID = ggSubEx.GGsID AND ggEID=51 AND WorkTitle > "Airborne - Shepherd\'s Warning 2 - Pacific Ocean, December 2002" ORDER BY WorkTitle ASC LIMIT 1 == The only difference I could find is the ' in the second WorkTitle -- I tried stripslashes (no \ before the ') but that didn't help. Is this a mySQL bug? mySQL version 3.23.42 Thanks, -- Michael --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php