Hi there, I really get nuts.... Macromedia Generator needs COLUMNS to create a chart. But data to be visualized is stored in one ROW (whole record). Therefore I need a SQL- query which generates one column out of one row like: my wish: my source: +--------+ | capt. | +--------+ ... | 10 | +-------+-------+-------+ +--------+ <- SQL- query <- | 10 | 20 | 30 |... | 20 | +-------+-------+-------+ +--------+ ... | 30 | +--------+ ... Every help is appreciated - otherwhise I really will fell the pain.. Thanks in advance Leo --------------------------------------------------------------------- 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