Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › Need Help with setting up recordset for downloads

Need Help with setting up recordset for downloads

Thread began 11/21/2009 9:40 pm by bac4571381904 | Last modified 12/21/2009 11:25 am by bac4571381904 | 5155 views | 29 replies

11/21/2009 9:45 pmbac4571381904

It looks like the pictures I attached are to small so i wrote out the fields for all three tables

Order Details Table
details_ID
first_name
last_name
details_orderID
details_productID
details_productname
detail_productdesc
detail_quantity
detail_price
timestamp
details_downloads
street1
zip

Orders table
orderID
first_name
last_name
orderReferenceID
ordervisitorID
ordertotal
orderdate
orderaddress
orderzip
City
State

Products Table
pro_ID
pro_name
pro_shortdesc
pro_longdesc
pro_price
pro_thumb
pro_download

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.