Hi all
i have a problem with my update query in php , i try to update the last record , i try with this but update all the records and not only the last i dont know what´s wrong ...any ideas?


$query = "UPDATE table1 SET Object1='one', Object2='two', Object3='three' WHERE id=LAST_INSERT_ID(table1.id)";


thanks a lot

$query = "UPDATE table1 SET Object1='one', Object2='two', Object3='three' WHERE id=LAST_INSERT_ID()";

LAST_INSERT_ID() with an argument return the value of the argument

i really have problems with that i do query but dont work ( dont make any update ) tell my plz if i have a sintaxys error or a concept mistake

$query = "UPDATE $table SET pregunta1='one', pregunta2='two', pregunta3='three' WHERE id=LAST_INSERT_ID()";

test to write you query like this one

$query = "UPDATE $table SET (pregunta1,pregunta2,pregunta3 )= ('one','two','three' ) WHERE id=LAST_INSERT_ID()";