populating a checkbox from database

[eluser]obiron2[/eluser]
If I have this right, you want to list all of the products with a checkbox ,but only tick the box if the shop sells that product.

rewite your db query.

select p.productID,count(s.productid) from products p left join shopproducts s on p.productid = s.productid
where s.shopid = $shopid
order by productid


What you will get is a list of all products (left join) and a 1 if the shop sells that or 0 if it does not.

You can then use the 1 and 0 to decide whether to activate the checkbox.

Obiron