insert array

[NZ_Kiwis]

I want to insert a arry text into my MySQL DB.

$Items = $_SESSION['cart'];

Like this then

$result = mysql_query ("UPDATE GLAMOUR_ORDERS SET OrderNumber = '$ordernumber', ItemsArray = '$Items', Address = '$Address', Name = '$Name', Phone = '$Phone', Email = '$Email'") or die("Database insert failed: " . mysql_error());

In my DB it just shows Array

How can I get it to show the content of my array

[Piranha]

I suggest that you read up on database normalization.

[NogDog]

If you are storing the array simply as a means of providing a session-like means of having that array persist among multiple scripts, then you will probably want to user [man]serialize/man and [man]unserialize/man when storing and recalling the array.

If on the other hand you want to store it as more meaningful data accessible from the DB for order processing and such, then I would agree with Piranha that this is not a good approach: you need to break the data up into a normalized table/column structure and allocate the array elements to those columns.