updating mysql array

[etoast]

Hello
If I had a page showing lots of different types of vegetables and each vegetable had a unique id. How would I allow logged in user "David" to click a button next to "Cabbage" and that would add the unique id for cabbage to David's profile?

I would like David's vegetable profile to be in this format: 134,165,45,24 where each value is different vegetable that he has bookmarked, and each time he visits he can add to (or delete from) his vegetable bookmarks.

I am using MySQL and it is the array storage and manipulation that I am stuck with. The main database and the user registration is all in place.

Any advice greatly appreciated!
Kind regards

[bradgrafelman]

I would just make it a VARCHAR/TEXT field (choose which one to use based on # of array items you think you'll have) and use something like:

$query = "UPDATE profile SET arrayField = CONCAT(arrayField, ',$newID') WHERE username = '$username' LIMIT 1";