trouble updating WHERE 2 columns must have a certain value
Posted: Mon Jan 22, 2007 5:10 pm
i'm trying to update my table, but the coordinates must fall under TWO specifications. not just one. i'm having trouble figuring out how to do this.
my code:
my table:
where's my mistake(s)?
my code:
Code: Select all
<?php
if(isset($_POST['selected_value'])){
$sql = "UPDATE item_options_linked
SET selected_value_id = ". $_POST['selected_value'] ."
WHERE (item_id = ". $_GET['itemID'] ." &&
option_id = ". $_POST['option_id'] .")";
mysql_query($sql) OR die(mysql_error());
}
?>Code: Select all
mysql> SELECT * FROM item_options_linked;
+-----+---------+-----------+-------------------+
| id | item_id | option_id | selected_value_id |
+-----+---------+-----------+-------------------+
| 13 | 6 | 6 | NULL |
| 14 | 0 | 5 | NULL |
| 9 | 4 | 5 | NULL |
| 11 | 6 | 5 | NULL |
| 10 | 4 | 6 | NULL |
| 15 | 0 | 6 | NULL |
| 17 | 7 | 5 | NULL |
| 18 | 7 | 6 | NULL |
| 19 | 4 | 8 | NULL |
| 20 | 6 | 8 | NULL |
| 21 | 7 | 8 | NULL |
+-----+---------+-----------+-------------------+