XFPfHY4Z

1CREATE TABLE IF NOT EXISTS messages ( 
2  mid int(11) NOT NULL auto_increment,
3 subject text NOT NULL,
4  message text NOT NULL,
5  fromid varchar(255) NOT NULL default '',
6  toid varchar(255) NOT NULL default '',
7  status varchar(255) NOT NULL default '',
8  date varchar(255) NOT NULL default '',
9  time varchar(255) NOT NULL,
10  PRIMARY KEY  (mid)
11) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2825 ;`
12
13
14SELECT 
15IF(messages.toid = '$uid' OR messages.toid = '$uid', messages.fromid, messages.toid) friend1,
16messages.message, messages.fromid, messages.toid, messages.date, messages.status, messages.time
17FROM
18messages 
19WHERE (messages.toid='$uid' OR messages.fromid='$uid') AND messages.status!='2' ORDER BY messages.time DESC, messages.mid DESC