[SOLVED] Trouble updating records..

[vomitbomb]

I'm able to update the records using this code, but it updates all the records in the database not just the one row that I want.

 

here is the code.

//create a query
$sql = "SELECT * FROM orders WHERE lname='$search'";
$result = mysql_query($sql, $conn);
$row = mysql_fetch_array( $result );

// Update record
$row = mysql_query("UPDATE orders SET status='2' WHERE status='1'") 
or die(mysql_error()); 

 

help appreciated

[vomitbomb]

lol think I worked it out already

 

changed status='1' to status'$row'

 

[vomitbomb]

ok nope, didn't work..

[haku]

If it is updating all records, then all records have a status that is equal to 1. You need to find a different way to identify the records you want to update.

[vomitbomb]

yeah mate that's what I'm asking help for.

 

I want to only change the status for the order that is shown in the $row variable.

[haku]

"UPDATE orders SET status='2' WHERE lname='$search'"

[vomitbomb]

Thanks mate, you're a legend.