RE: [PHP] mysql query with exclude

.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 query with exclude Sounds like you need a join. Maybe

RE: [PHP] mysql query with exclude

.user1_sessionid = $thisuser)) or (c2.user1_sessionid 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 query

[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

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));