SELECT DISTINCT LEFT JOIN select list ERROR

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

jonnyfortis
Forum Contributor
Posts: 462
Joined: Tue Jan 10, 2012 6:05 am

Re: SELECT DISTINCT LEFT JOIN select list ERROR

Post by jonnyfortis »

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"
Post Reply