Ok, it acured to me that the feature I am trying to include here would be an obvious one to include in a products shopping cart. Then I remember that I had purchased the PowerStore2 but hadn't had a chance to mess with it.
So I set up a local testing version of it and sure enough, on the Products_Update.php page it has the checkbox I am wanting to create.
On that page it simply writes a 1 when checked, into a column of the products database. I think I understand that.
However, on the Products_Results.php page where the public sees the list, I can't figure out exactly how the product shows if given a value of 1, or is hidden if given a value of 0.
I see a WHERE statement for the "ProductLive" column in the recordset. But I can't make sense of it because there are so many other things going on there.
I think it is saying to display records by ID AND ProductLive <> 0, meaning that if a record has an ID and the value of the column ProductLive has a value greater than or lesser than 0, then show that record. But I can't get it to work for me in my DA records.
Am I going in the wrong direction?
TroyD
