Jump to content

Archived

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

ashish4172

query bug

Recommended Posts

hi

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..


table:thread_reply
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.