update a column between a range

[dflow]

ok this should be simple but i messed it up:

SELECT LangHEB

FROM contact_form_BACKUP

UPDATE contact_form_BACKUP

SET Lang='1'

WHERE ProductID

BETWEEN '100' AND '120'

 

this is what logically i want to do

 

what am i doing wrong?

[T Horton]

Hi

 

Not sure why you are putting the "SELECT" statement at the beginning, but in order to update any records where the product ID is between 100 and 120, you would need to use the following SQL:

 

<?php
    $sql = mysql_query("UPDATE contact_form_BACKUP SET Lang='1' WHERE ProductID BETWEEN '100' AND '120'");
?>

 

Hope this helps.

 

 

 

 

Tom

[dflow]

thanks