Automatic line deletion

[jonki]

I am sure ths is simple but I can't find the mistake - I get a sql syntax error .....

I do a statistical analysis of every search done on my site and therefore have a massive database and I am only interested in the last, say, 10 000 searches - I have reached that 10 000 so now all I want to do is, right after the line of code that inserts new data, put a line of code which deletes the first bit of data.

 
$query = "DELETE FROM marketanalysis ORDER BY user_id LIMIT 1";  

$result = mysql_query($query);

This doesn't work.....

I have tried apostrophes, LIMIT 0,1, including a where statement .. nothing seems to work. I've even restarted my computer as a last resort.

Thanks a lot.

Jon

[Natty_Dreadlock]

hi,
i think the ORDER BY is the problem...
i don't know whether it works but try something like:
DELETE FROM marketanalysis WHERE MIN(user_id) LIMIT 1
i think there's some sql funtion to determine the minimum but probably u gotta look it up in the docu.
hth

[Natty_Dreadlock]

hi,
i think the ORDER BY is the problem...
i don't know whether it works but try something like:
DELETE FROM marketanalysis WHERE MIN(user_id) LIMIT 1
i think there's some sql funtion to determine the minimum but probably u gotta look it up in the docu.
hth

[Roger_Ramjet]

ORDER BY is not the problem. Difficult to know what is going wrong without seeing the DB schema. Is the user_id UNIQUE??

[jonki]

the user_id is auto_increment and therefor each one has a unique value.

I am sure that it is a simple syntax error as I got the code from another thread in this forum and supposedly it worked.