I wonder if this query is possible in mysql? I have tried it but it does not work. I am not sure if I have done it the right way.
"UPDATE product SET selected = 'yes' WHERE product_id BETWEEN '$product_id_low' AND '$product_id_high'"
UPDATE product SET selected = 'yes' WHERE product_id >= '$product_id_low' AND product_id <='$product_id_high'
Your BETWEEN syntax looks fine to me - what was the MySQL error message produced?
