problem solved! Thanks Mark for the message offlist.
I used something like:
select threads.*
from threads
left join replies
on threads.id = replies.tid
and (threads.stamp > {$weekago} and replies.stamp > {$weekago})
order by threads.id DESC
Thanks,
Justin
on 19/11/02 9:22 PM, Justin F
Hi all,
Not sure if I should be using distinct, or some sort of complex WHERE query,
so here goes:
I have two related tables:
threads
id,udi,message,stamp
replies
id,thread_id,uid,message,stamp
(the stamps are unix timestamps)
What I'd like to do select * from the table threads, selecting al