populating a checkbox from database

[eluser]nikefido[/eluser]
The P and S were aliases to the tables "products" and "shopproducts" so if you just removed them and refered to every field with its tablename (tablename.fieldname), then that should not be the cause of the "error"

You are probably not getting all of your products because this query will (I believe) only give results where you're IDs match up

Hope that helps (and is correct...)