SELECT group_concat( DISTINCT '',`fromfirstname`,': ','',`message` SEPARATOR '<br />' ) as Message,`fromusername`,`tousername`,`sessionname`,tofirstname,concat(DATE_FORMAT(`sentdate`,'%W , %b %d , %Y '),' ',`senttime`) as DateandTime FROM `tableins` WHERE ((fromusername='" + sess + "' or tousername='" + toid + "') OR (fromusername='" + toid + "' or tousername='" + sess + "')) AND sentdate='" + DateTime.Now.ToString("yyyy-MM-dd") + "' GROUP BY `sessionname` ORDER BY `id` DESC
group_concat_max_len
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)