Using initial query to determine column array info?
Posted: Tue Sep 04, 2007 6:43 pm
Hi all,
I have a table with data similar to this for example:
and I'd like to create an array with the following info:
(order not essential)
The question then, is: Using MySQL 4.x, Is there a way to have the initial query return the results I need, without having to parse through the table and manually push the data into an array?
My SQL is still quite beginner level.
Any advice would be really appreciated!
Rob
I have a table with data similar to this for example:
Code: Select all
1
1
2
1
2
2
3
4
6
5
5
1Code: Select all
1, 2, 3, 4, 5, 6The question then, is: Using MySQL 4.x, Is there a way to have the initial query return the results I need, without having to parse through the table and manually push the data into an array?
My SQL is still quite beginner level.
Any advice would be really appreciated!
Rob