Jump to content

ashish4172

New Members
  • Posts

    4
  • Joined

  • Last visited

    Never

Posts posted by ashish4172

  1. 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
×
×
  • Create New...

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.