- Easy AJAX powered checkout system
- Receive the orders directly through email within 30 seconds of placed order
- Easy customization for those who want to modify their site
- Set the hours you would like your store open
- Turn your store off and on through the administration panel
- Enable Credit or disable credit cards
- Enable or disable delivery and delivery fees
- Modify your home page directly from a control panel
- Add Edit and delete categories to your menu
- Add Edit and delete menu items with extented features
- Each site has a contact us page for customer questions
- Edit the hours you would like your online store open
- Add an addition cost for delivery, tax prices or order processing fees
- Built In newsletter system
- Free updates
mysql
mysql update from another table
Recently I needed to update a bunch of rows in mysql with information from another table. I will explain how to do this simple process.
- Open up phpmyadmin or similar database editor
- view the sql query below
UPDATE updatefrom p, updateto pp
SET pp.last_name = p.last_name
WHERE pp.visid = p.id
Lets say we have 2 tables one named main and one named updateto and one named updatefrom, In the first line we assign variables to these t tables (p and pp) from there we can call column names using this format table.columname. If we had first_name and last_name in both tables and wanted to update the “updateto” table with the info from “updatefrom” this is how you would write it.