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]