Complex SELECT

[matthewst]

I have a table like this:

a 1
a 2
a 3
b 1
a 4

Right now it echoes like this:

a 4

I need it to echo like this:

a 1,2,3,4

Any Ideas?

[saidbakr]

Hi,

Please supply more details to allow every one able to, clearly, understand what you need.

However,

SELECT field_2 FROM table WHERE field_1 = 'a' ORDER BY field_2 ASC

This was the sql which will return as a query result 1,2,3,4 Of course after looping through the result array and you can add a before the loop start.