title: UPDATE query is not working with LIMIT
body: <p>hi i am using an UPDATE query with limit 0,1 where i have to update the first row which matches the condition which i m giving in the query</p>
  
  <pre><code>mysql_query("UPDATE `product_option` SET `input_value`='$color_a',`input_price`='$color_price_a' WHERE `product_id`='$_REQUEST[pid]' and `input_type`='option' LIMIT 0,1"); 
  </code></pre>
  
  <p>in my sql table the $_request[pid] is repeating many times so on that rows in which $_request[pid] is matching, i want to update the first row on it but this query is not doing any thing the data is still same which i have added.</p>
  
  <p>any suggestion will be appreciated</p>
  
  <p>here is the image of the table</p>
  
  <p><img src="https://i.stack.imgur.com/T8e91.jpg" alt="enter image description here"></p>