This is my (very simple) query :
DELETE FROM privatemessage
WHERE user_ID = '15'
ORDER BY date
LIMIT 1
And this is the result:
SQL-query:
DELETE FROM privatemessage WHERE user_ID = '15' ORDER BY date LIMIT 1
MySQL returned: You have an error in your SQL syntax near 'ORDER BY date LIMIT 1' at line 1
why ?