Basically I want to prune a table in the database, leaving only the top 5 posts.
Doing this:
Errors this:PHP Code:mysql_query("DELETE FROM shoutbox LIMIT 5, 500");
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 500' at line 1
Is there a certain way to prune a table or does anybody have an answer??![]()
Rudi![]()










Reply With Quote