Help with database query.

You can do something like that (with mysql).

PHP Code:

delete from comments where id = 10
select id from comments where discussions_id = [discussion_id] order by id DESC limit 1
update discussions set last_comment_id = [the return value of the select above] 


Haha i knew I was over thinking this!

It was the query that I could not think of. Thats great mate thank you very much for the swift reply =)