RE: [PHP] mysql query with exclude

Turmelle [mailto:[EMAIL PROTECTED] >>Sent: zondag 28 november 2004 2:25 >>To: [EMAIL PROTECTED] >>Cc: [EMAIL PROTECTED] >>Subject: Re: [PHP] mysql query with exclude >>Sounds like you need a join. Maybe something like: >> >>select * from chat c1, >&g

RE: [PHP] mysql query with exclude

id if(c1.user2_sessionid = $thisuser)); Can I do something like this? >>-Original Message- >>From: Ligaya Turmelle [mailto:[EMAIL PROTECTED] >>Sent: zondag 28 november 2004 2:25 >>To: [EMAIL PROTECTED] >>Cc: [EMAIL PROTECTED] >>Subject: Re: [PHP] mysql q

Re: [PHP] mysql query with exclude

Sounds like you need a join. Maybe something like: select * from chat c1, chat_online c2 where UNIX_TIMESTAMP(c2.activity)=$limit_time and c2.session_id = $thisuser and ((c1.user1_sessionid = $thisuser) or c1.user2_sessionid = $thisuser));

[PHP] mysql query with exclude

Hey all, Hope you all have fun this saturday evening :) I'm sure i'm having fun except i'm kinda stuck... Ok here goes... I have 2 tables, one with the people online (chat_online): session_id activity And a second one where i keep the conversations between people(chat): user1_sessionid us