Hello, I've got a table with articles and a table with categories. Using a 'temporary' table it's easy to assign multiple categories to an article. The insert is no problem, because I can perform two queries, but for the output I get one row for every every category. But i like to get one row with every category name in a field, separated by a special character or something similar. Has anyone an idea to do that without a extra query for each article?
Regards, Andreas Ahlenstorf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]