Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Mysql self join to match current record to previous record
enigma1 - 3:11 pm on Oct 5, 2010 (gmt 0)
have you tried to append limit 1 at the end of the query?
...WHERE curr.siteid=1 order by curr.date limit 1
Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4211470.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com