ok let me explain:
I have this forum table, the uread field is the field in which every user (login) separated by space is added when he reads the message:
in the update function I check if the user is not in the uread (longtext) field, if he is not, I will add his name to that field.
CREATE TABLE `forum` (
`mid` int(11) NOT NULL auto_increment,
`fm` varchar(12) default NULL,
`to` varchar(10) default NULL,
`sj` varchar(32) default NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`mid`)
The problem is that every time the user reads the message and he is not in the uread (longtext) field, I have to load all data form the uread row and add his login name to that row.
I was thinking to some mysql query that would concat the existing data, separated by space, with the login name of the user.
I don't know how to do that.