help with mysql

Anon

using mysql_fetch_array, can you split up 1 individual table record when pulling the data back out, it comes back out as a large block of text eg

1 x BB004 Baby Soft Soothing Lotion 75ml 4.99 3 x SK455 Tea-Tree & Kanuka Blemish Stick 8ml 2.45 3 x SK456 Tea-Tree Skin Wash 250ml 5.95 1 x HA496X Tea-Tree with Lemon & Rosemary Shampoo 150ml 3.99 1 x SK453 Natural Antiseptic Cream 30gm 3.99 1 x BT353 Indulge Bath Soak 210ml 6.99 1 x HA490 Melissa and Grapefruit Shampoo 150ml 3.99 3 x SK451 Lavender Gel 50ml 4.40 1 x EO141X Lavender Pure Essential Oil 20ml 7.90 1 x MA428 Muscle Fatigue Oil 100ml 6.90 1 x EO206 Peppermint 9ml 4.15

or should it not be put in as a single variable but an array or multiple variable

Anon

mysql_fetch_array returns a field as an array. You can return it as a enumerated array (keys as numbers) or as an associtaive array (keys as field names) or both.

Anon

my database table is called items in that i have a field called items, in that field are all the items ordered by the customer. to print the extracted data iam using the following

$Link = mysql_connect ($Host, $User, $Password);

$Query2 = "SELECT * FROM $TableName2 WHERE cartId LIKE ('$cartId')";

$Result2 = mysql_db_query ($DBName, $Query2, $Link);

while ($Row2 = mysql_fetch_array ($Result2)) {
print ("<TD WIDTH=\"600\" COLSPAN=\"2\" ALIGN=LEFT><FONT FACE=\"Verdana, Arial, Helvetica, sans-serif\" SIZE=\"2\">$Row2[items]</FONT></TD>\n");

}
mysql_close ($Link);
?>

this is the basic code there are other bits but what am i doing wrong, the items field is one entry going into the database but can it come out and be split by a delimiter