[RESOLVED] Create an array in php from MySQL

[ade234uk]

I have data in one of my fields in the following format 1,2,3,4

I need to create an array in php once I have selected it from MySQL
Once I have this in an array, In then use a foreach loop to perform the next operation.

I have tried the following to create the array, where it inserts the row from the database directly, but this does not work. This is what I have tried below.
$a = array($row['group_numbers']);

I decided to try this manually so I entered it directly and saved .php page, and it worked.
$a = array(1,2,3,4)

So basically what I need advice on is how I pull the data in this format 1,2,3,4 from MySQL and create an array using php.

[coldwerturkey]

how about just using explode()?

$row['group_numbers'] = "1,2,3,4"; //from mysql

$numbers = explode(",", $row['group_numbers']);

foreach ($numbers as $num) {
	//do somthing
}

[ade234uk]

Thank you very much, that works brilliantly. I have been scratching my head for hours over this. Again thank you.

[Piranha]

It seems that your database is not normalized. If it where you wouldn't store more than one value in the column. I recommend you to normalize the database to avoid future problems.