[SOLVED] update mysql with $_SESSION

[Kano]

Hi there,

 

I would like to update the mysql database using a $_SESSION array. The array looks like this when using print_r

 

[VA001] => 8 [VA002] => 26 etc.........

 

What i would like the SQL to do is update table column = value of $_SESSION array where column = key of $_SESSION array.

 

Could someone show me how to write this and is there anythong that needs to be done to the array such as stripslashs or trim or anything like that.

 

Thanks.