SELECT * FROM `messages` WHERE `to` = 'room' AND `to` = '$user' ORDER BY `id` DESC
0
public messages, private messages same page
Started by derek.sullivan, Feb 01 2009 04:03 PM
1 reply to this topic
#1
-
- Members
-
- 341 posts
Jedi In Training
- Gender:Male
- Location:Georgia
- Interests:preaching, programming, music, friends, outdoors, moves, books
Posted 01 February 2009 - 04:03 PM
What I want to do, is alert the user when they have a new PM on the message screen. It will display something like "You got a new pm!" (note: I do not use the javascript alert for this), and only the receiving user will see the PM alert, any suggestions? Could I do this?
#2
-
- P2L Staff
-
- 3,827 posts
PHP Master PD
- Gender:Male
- Location:Here
- Interests:Web Development
Posted 01 February 2009 - 05:35 PM
Yes and no. You would actually want to use an OR instead of an AND. Then it should work as i believe you want it to work.
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users
