Welcome Guest, Not a member yet? Register   Sign In
populating a checkbox from database
#11

[eluser]obiron2[/eluser]
It looks like it should work.



Try changing the following:

The productsbyshop records should have a unique reference id.

change 'count(productsbyshop.product_id)' to count '(productbyshop.uniqueid)'

if it still doesn't work, try removing the count and group and just listing the product.product_id and productbyshop.unique_id.

You should get all product.product_id and NULL where the productbyshop record does not exist.

Obiron


Messages In This Thread
populating a checkbox from database - by El Forum - 01-11-2009, 08:27 PM
populating a checkbox from database - by El Forum - 01-11-2009, 09:11 PM
populating a checkbox from database - by El Forum - 01-11-2009, 09:17 PM
populating a checkbox from database - by El Forum - 01-11-2009, 09:31 PM
populating a checkbox from database - by El Forum - 01-11-2009, 09:43 PM
populating a checkbox from database - by El Forum - 01-12-2009, 07:27 AM
populating a checkbox from database - by El Forum - 01-12-2009, 08:22 AM
populating a checkbox from database - by El Forum - 01-15-2009, 08:40 PM
populating a checkbox from database - by El Forum - 01-15-2009, 09:53 PM
populating a checkbox from database - by El Forum - 01-16-2009, 01:23 AM
populating a checkbox from database - by El Forum - 01-16-2009, 06:01 AM
populating a checkbox from database - by El Forum - 01-16-2009, 08:54 PM



Theme © iAndrew 2016 - Forum software by © MyBB