csv creation problem

[perezf]

Hello everyone, currently i created a script that exports data from a database.

I have a bit of a problem though since a CSV is comma delimited.

This field that i need to export data from has commas in it and that screws up the whole file.

Does anyone have a solution?

[F1Fan]

Did you try adding quotes around the values?

[Maq]

Is there any other unique value that separates them?

[perezf]

yes i did here is a sample of what i did

while($row = mysql_fetch_array($result)) { 
$csv_output .= 
				'"' . $row['products_id'] . '",' . 
				'"' . $row['products_name'] . '",' . 
				'"' . $row['products_model'] . '",' . 
				'"' . 'R' . '",' . 
				'"' . $row['products_price'] . '",' . 
				'"' . 0 . '",' . 
				'"' . '' . '",' . 
				'"' . '' . '",' . 
				'"' . 0 . '",' . 
				'"' . 0 . '",' . 
				'"' . 0 . '",' . 
				'"' . $row['products_name'] . '",' . 
				'"' . $row['products_description'] . '",' . 
				'"' . $row['products_description'] . '",' . 
				'"' . '' . '",' . 
				'"' . 'default' . '",' . 
				'"' . 'dsimg' . '",' . 
				'"' . 3 . '",' . 
				'"' . 0 . '",' . 
				'"' . $row['products_image'] . '",' . 
				'"' . $row['products_image'] . '",' . 
				'"' . $row['products_image'] . '",' . 
				'"' . 0 . '",' . 
				'"' . 0 . '",' . 
				'"' . 0 . '",' . 
				'"' . 0 . '",' . 
				'"' . 0 . '",' . 
				'"' . 1 . '",' . 
				'"' . 1 . '",' 
				;
$csv_output .= "\n";
}