Re: Saving an array to a mySQL table

If I wasn't clear I am trying to figure out how to save an array in a
mySQL table, both the array and it's value ... in this instance the
product reference and the quantity the customer has decided on.  Ron

On Tue, 2008-05-13 at 23:11 -0400, Ron Piggott wrote:
> I am writing a shopping cart.  I am now ready to take the order from
> being in a session variable
> $_SESSION['product_selected'][$product_reference_number] to store it
> into the orders table.  
> 
> While the products selected are being displayed in a loop I have the
> piece of code
> 
> $final_order .= $_SESSION['selection'][$product_reference]
> 
> Of course this is only capturing the quantity of $product_reference, not
> assigning the array to $final_order and the quantity being ordered.
> 
> I am trying to maintain inventory control in my shopping cart and want
> to be able to query the orders table to find out what products have left
> so I don't sell something I don't have.  
> 
> Ron
> 
-- 
[email protected] 
www.actsministrieschristianevangelism.org 

Acts Ministries Christian Evangelism 
"Where People Matter" 
12 Burton Street 
Belleville, Ontario, Canada   K8P 1E6 
 
In Belleville Phone : (613) 967-0032 
In North America Call Toll Free : (866) ACTS-MIN 
Fax: (613) 967-9963