Re: SELECT DISTINCT LEFT JOIN select list ERROR
Posted: Wed Oct 10, 2012 4:00 am
not sure what that post is.
i have filtered out the size if set to 0 by doing this
$query_rsProdList = sprintf("SELECT * FROM poochieProd, poochieCat, poochieSizes, poochieStock WHERE poochieProd.CatID = poochieCat.CatID AND poochieProd.ProdID = poochieStock.ProdID AND poochieSizes.SizeID = poochieStock.sizeID AND poochieProd.ProdID = %s AND poochieStock.sold !=1"
thats done the job, but ideally i want to still show the size and have a sold out next to it then not allow them to select that option by an alert saying " this item is sold out please select another size or contact us here"
i have filtered out the size if set to 0 by doing this
$query_rsProdList = sprintf("SELECT * FROM poochieProd, poochieCat, poochieSizes, poochieStock WHERE poochieProd.CatID = poochieCat.CatID AND poochieProd.ProdID = poochieStock.ProdID AND poochieSizes.SizeID = poochieStock.sizeID AND poochieProd.ProdID = %s AND poochieStock.sold !=1"
thats done the job, but ideally i want to still show the size and have a sold out next to it then not allow them to select that option by an alert saying " this item is sold out please select another size or contact us here"