Alright, I have two product tables, one USA and one International. Now, each of these holds picture information for each product in additional to regular info on the products themselves. However, a select few of the international countries use a different picture set. The way I implemented this is that I had the one set under the international list and the other under the us, then I used a special query to select from the international product list, except for the pictures. However, there is one problem with this method. As it is, because the international product list has slightly different products that do not have pictures situated in the USA product list, some products are not being displayed.
This is the query:
$specQuery = "SELECT f.id, f.itemid, f.itemname, f.itemprice, f.itemweight, p.itempic, f.itemdn, p.picheight, p.picwidth FROM foreign_prodlist f, product_list p INNER JOIN foreign_finas ON f.itemid = foreign_finas.itemid WHERE f.itemid = p.itemid ORDER BY f.id ASC;";
However, the one product, product 031 does not have any information in the product_list table so it does not display to certain international users (of specific countries).
