I have this code to update a product price in the product table:
Code: Select all
$this->db->query("UPDATE " . DB_PREFIX . "product SET price = '" . $this->db->escape($dbprice) . "' WHERE ".$column." = '" . $reference . "'");
I can get the product_id from the product table without issue so I should be able to take that product_id and check the product_to_store table to see what store that product_id is in.
So I am looking for a simpler tutorial then these:
http://www.w3schools.com/sql/sql_join.asp
I am wishing to learn so please don't give me complete code. I know that might be what lots of folks are searching for but that would help me in the short term but I would be back to bug you all on a later issue so I would rather be pointed to an example.
Thanks!
Mike