close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Wish List Database

Thread began 4/25/2014 1:40 am by sabastian130416448 | Last modified 5/07/2014 9:16 am by sabastian130416448 | 6576 views | 24 replies

sabastian130416448

Wish List Database

Hi guys.

I am trying to create a Wish List for my website but I have run into a little wall.

I understand from reading some of the other posts that I need to create a new Database Table that will store the product info and user info instead of pulling the info from the Database as in the case with the Add To Cart button.

My problem comes in that I have more than one Table in my Database where some of the products contain the same Product Id. The difference comes in the Description of each product so they are unique in their own way. I thought about this and came to the conclusion that to store the info in the Wish List Table I will have to assign a different ID to the products.

Up to here I am still ok my PROBLEM is that say I have a Table Called ProductsFruit and another Table called ProductsVeg. Now in Table ProductsFruit the first item is Apples with ID1, selling at $1.00. In Table ProductsVeg the first item is Carrots with ID1 selling at $1.20.

The client then adds 1 unit of Apples and 2 Units of Carrots to the Wish List. In the WishList Table the Carrots and the Apples are assigned new ID's because there can't be two ID1's, the Clients ID is saved and the Product Details are stored. Now if say tomorrow the Apples become $1.10 or even sells out, how will the data in the Wish List be updated?

How do I set the Wish List when a customer logs in to get the correct info from the correct table to find out if the price is still the same or if the product has maybe been sold out in the mean time? I can see how this will work if you are using only one table but I am not sure how to do this with different tables especially if the Product ID has to change when inserting products into the Wish List. I have about 20 Tables in my Database as each Table represents a different Company we sell products from.

Thanks for any help and advice.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...