Jump to content


Photo

query bug


  • Please log in to reply
No replies to this topic

#1 ashish4172

ashish4172
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 08 March 2006 - 02:23 PM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users