I can Insert, Delete but not UPDATE?

[daok]

This is what I got in my DIE message :

Query was empty

This is my SQL Query:

UPDATE pp_usagers SET userName= 'Daok', userEmail = '[e-mail]' WHERE userId = 1

I do have a userId 1 and I have a table called pp_usagers

I can do Insert and Delete so I suppose that my connection is well established but why can't I Update?

One important thing : When I test directly my query in phpmyadmin I see 1 row changed...... why in my code I can't?

$sqlSqlQuery = "UPDATE `pp_usagers` SET `userName`= 'Daok',  `userEmail` = '[e-mail]' WHERE `userId` = 1";

$result = mysql_query($strSqlQuery) or die("Erreur de mise à jour 1 : " . $sqlSqlQuery ." <br> " . mysql_error());

[tomhath]

Most of the time when php creates variables automatically it's what you want, but sometimes it really, really bites you.

$sqlSqlQuery or $strSqlQuery ?

$sqlSqlQuery = ...;

$result = mysql_query( $strSqlQuery )...

[daok]

thx 🙂