update query not working (php, mysql)

Question

I'm trying to update information in my database but it is not updating and i'm not getting any error. But when I execute the query with MySQL Query Browser it works and the information is updated correctly.

function cancelaDetalleOrden($id_orden,$id_pos,$id_componente)
{   
conectar();
$cancelado= "Cancelado";
$terminado= "Terminado";
echo $id_orden." ".$id_pos." ".$id_componente;//to check if data is retrieved
$query ="UPDATE procesos_orden 
             SET `status` = '$cancelado' 
             WHERE (`status` != '$terminado') = '1' 
               AND `id_orden` = '$id_orden' 
               AND `id_posicion` = '$id_pos' 
               AND `id_componente` = '$id_componente';";
mysql_query($query)or die("Error ".mysql_error());
}

This is really weird because I have other functions where I update and they work well.

Do you really need the ticks (`) around the column names in PHP? — Dirk
– Dirk, Commented Jun 22, 2011 at 18:01
Try assigning the last statement to a variable; something like: $result = mysql_query($query) or die("Error ".mysql_error()); — afaolek
– afaolek, Commented Jun 22, 2011 at 18:05

Johan · Accepted Answer · 2011-06-22 18:28:23Z

1

this looks like a bug

(`status` !=   '$terminado')= '1'

without the =1 i suspect is what you wanted to do.

(`status` !=   '$terminado')

If it still doesn't work and it doesn'tgive an error, then you have a logical bug.

Here's how to fix it.

Run this query and see which records you are updating.

"SELECT * FROM procesos_orden 
 WHERE (`status` !=   '$terminado')= '1' 
   AND `id_orden` = '$orden' 
   AND `id_posicion` = '$id_pos' 
   AND `id_componente` = '$id_componente';";

edited Jun 22, 2011 at 18:28

Johan

77.4k28 gold badges204 silver badges346 bronze badges

answered Jun 22, 2011 at 18:00

Gidon Wise

1,9161 gold badge11 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Steve Robbins Over a year ago

You don't need the parenthesis either.

Kijewski · Accepted Answer · 2013-01-11 17:18:53Z

0

Use this but see properly where I have used single quote, double quote, and tilde. Just change your variables with mine.

I have written values like this: '".$var."'

$up = mysql_query("UPDATE signup set `fname`='".$fn."',`lname`='".$ln."',`city`='".$ct."',`uname`='".$un."',`pass`='".$ps."',`eml`='".$ema."',`strm`='".$sm."',`add`='".$ad."' where `id`='".$uid."'") or die(" ".mysql_error());

This works 100% in my php page.

edited Jan 11, 2013 at 17:18

Kijewski

26.1k14 gold badges108 silver badges149 bronze badges

answered Jan 11, 2013 at 16:55

Alpesh Rathod

1

Collectives™ on Stack Overflow

update query not working (php, mysql)

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related