quote:

---

Originally posted by X002548

Please POST THE DDL of the Table

Sample DATA in DML Form

And what the expected results should be

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

---

CREATE TABLE `db1_etchat_user` (
  `etchat_user_id` int(8) NOT NULL AUTO_INCREMENT,
  `etchat_username` varchar(200) NOT NULL,
  `etchat_userpw` varchar(40) DEFAULT NULL,
  `etchat_userprivilegien` varchar(15) NOT NULL DEFAULT 'gast',
  `etchat_usersex` varchar(1) NOT NULL DEFAULT 'n',
  `etchat_reg_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `etchat_reg_ip` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`etchat_user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

CREATE TABLE `db1_etchat_useronline` (
  `etchat_onlineid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `etchat_onlineuser_fid` int(8) NOT NULL,
  `etchat_onlinetimestamp` bigint(20) NOT NULL,
  `etchat_onlineip` varchar(255) NOT NULL,
  `etchat_fid_room` int(11) NOT NULL DEFAULT '1',
  `etchat_user_online_room_goup` int(6) NOT NULL,
  `etchat_user_online_room_name` varchar(100) NOT NULL,
  `etchat_user_online_user_name` varchar(200) NOT NULL,
  `etchat_user_online_user_priv` varchar(20) NOT NULL,
  `etchat_user_online_user_sex` varchar(1) NOT NULL,
  `etchat_user_online_user_status_img` varchar(200) DEFAULT NULL,
  `etchat_user_online_user_status_text` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`etchat_onlineid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;