hello, I have a problem in mysql 4.0.7
this piece of code worked until version 4.0.4 SELECT @ID:=''; SELECT @ID:=CONCAT(@ID,',',MAX(ID)) FROM WF_Users GROUP BY GUID; SELECT @ID; the result was: ",1,2,.....,n". but today doesn't works anymore now the result is ".n" where n is the last max(id) value in the result set. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php