scanning db field for words

[viveleroi0]

I have a database table of products, which has a field that lists a price. When the item is ordered, the script adds the words ON HOLD to the price field. So, the result would be "$85 - ON HOLD". How can I make a script that would check to see if the field has the - ON HOLD part - if so then display an error, if not let the visitor order the product?

[Krakken]

Ah, this is quite simple. First remove the "ON HOLD" section and add another column to your table. Name the column something like "hold" and then go through your products if the item is on hold add "HOLD" or something under that column for the product.

All you would need to do then is query that column and check if it contains "HOLD" or not.

• Krakken

[viveleroi0]

well I could do that but unfortunetely that would require me changing how severalk different program soperate. I did think of another way to do thisso thanks anyway!

[lurius]

then you must query like:

select id from table where price like '%ON HOLD'

-Lurius