This code works perfectly IF and only IF the product (represented by $query->row['p_id']) already is in the product_special table.
Code: Select all
$this->db->query("UPDATE `" . DB_PREFIX . "product_special` SET price = ' " . $specialdbprice . " ' WHERE product_id = ' " . $query->row['p_id'] . "'");
Code: Select all
$this->db->query("REPLACE INTO `" . DB_PREFIX . "product_special` SET price = ' " . $specialdbprice . " ' WHERE product_id = ' " . $query->row['p_id'] . "'");
Could someone help me understand how I could do this?
Thank you,
Mike