Jump to content

update a column between a range


dflow

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.