in reply to fetching data from MySQL
SELECT CONCAT("Line ", line_n, " ", GROUP_CONCAT(word ORDER BY word_position SEPARATOR " ")) FROM words GROUP BY line_n ORDER BY line_n;
GROUP_CONCAT is a powerful tool indeed - very useful in report building.
-sam
|
|---|