Functions

[Anon]

Hi,
Is there a function to turn off an ID value within a MySQL database. For example, i have a product catalog...if a particular product is not in stock i don't want that product and all its related values shown. Can i use check boxes to turn them off (from the admin page)? If so, what is the function or script?

Cheers,
micmac

[ccranium]

No, there's no value you can set to indicated whether or not a row is active.

However, you could add a bit field to your table called "Active" and set it to 1 if the product is in the inventory or 0 if the product isn't, then in your query to return the products add "WHERE Active = 1".

[gljaber]

Presumably somewhere there will be a field stating the number of products currently available. Use that value in an SQL statement, or later in PHP, to determine whether or not that product is to be shown.

HTH

glj