Jump to content


This topic is now archived and is closed to further replies.


query bug

Recommended Posts


I have a problem in query.I'm implementing the last posted reply
of threads.How can i get the recent replier of thread without using subquery
as i have mysql4 which doesn't support subquery...
please help..

fields: thread_id,thread_reply_date,thread_replier

i have tried

select thread_replier,max(thread_reply_date) from thread_reply group by thread_id;

datetime is stored in date field...

Pl help

Ashish Sharma

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.