Tables

[thefisherman]

Hello,

I would like to build a shopping cart using a database.
This database would then be filled with information the user clicked on. This by itself is not such a big problem.
The problem is, when a user deletes an item, how do i delete that row from the table (this is a dreamweaver table, not a MySQL table!)

On screen i mean, update the table..

TheFisherman

[DigitalExpl0it]

you should use sessions for this, it will makes things alot easier, faster and less head ach

[rcook]

Session are indeed faster and less of a headache, however, they don't allow a persistant shopping cart between visits.

If you do use a database table for your shopping cart, each entry should have some type of unique identifier. Then when the user deletes that entry from their shopping cart, you can simply delete from the table based on the unique identifier:

DELETE from shopping_cart_items WHERE cart_item_id='{$_POST['cart_item_id']}'

... or however you want to specify the id from the webpage.