eCart5.06 Dreamweaver Extension - Not pulling Data from Database?
Aug 20, 2012 4:53 PM
I created an Add to Cart button on my page but it is not pulling the data from the sample database that came with the eCart 5 program.
This is my first experience working MySQL and PHPMyAdmin. I have experience creating excel spreadsheets and created mailing list to print from the database, and I experience importing & exporting data from a contact management program I use on my computer.
I am not sure if it is similar? This stuff is all new so I have a number of questions.
1. I created my MySQL local host and I can access the PHPMyAdmin.
2. I have Inserted a eCart Object on a page I named az_ecart1.php.
3. On this page I inserted an eCart Add to Cart Button.
ATTACHED - are images of how I set up the Recordset and the bindings for the buttons.
Also attached is an image of the Recordset Physical_goods database that can be used with the eCart 5 extension.
Questions:
- The one Item listed on the Physical_goods database (see image) Remix does not show up on my page where I inserted the button?
- I assume the Items area in this database is to be populated with my product data to appear on the page...correct?
- How do I populate the physical goods area with my product data?
- What program do I use to create the database? My Apple TextEdit Program, Excel??
- Do I create the same 8 top row headings after ItemID, like ItemCartID ItemName etc with my product data below each heading column?
- ItemID - Does the ItemID identify and match up the product with the Add Cart button?
- Is the Unique ID automatically generated by the database?
- Do I have to create a different Recordset for each page
Your help is greatly appreciated.
Keitodd29
