Emergency

Announcement

Collapse
No announcement yet.

Help-a-Newb with query ...

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Help-a-Newb with query ...

    select distinct
    threads.id,
    threads.name,
    threads.readonly,
    threads.active,
    threads.forumidfk,
    threads.useridfk,
    threads.author,
    threads.datecreated,
    forums.name as forum,
    threads.author as username,
    threads.sticky,
    threads.views,
    conferences.name as conference,
    conferences.id as conferenceid,
    threads.lastpost,
    threads.msgcount as messagecount

    from
    (threads inner join forums on threads.forumidfk = forums.id)
    inner join conferences on forums.conferenceidfk = conferences.id

    where 1=1

    and threads.active = 1


    and threads.forumidfk =



    ======================================

    ... as it is now it works fine but I need to add the following condition :


    and users.testOnly =


    please help with the [select] and [from] (inner join?). Thank you very much.

    =====================================


    order by threads.sticky desc, threads.lastpost desc
Working...
X