CODEWITHSUNDEEP
phpmysqlsql-update
user6631314
user6631314

Reputation: 1966

Syntax for UPDATE of a record in MYSQL

Is the following update query a legal statement? It replaces the existing value with an empty value instead of the word gossamer. It does not fail as far as I can tell. It changes the value in the database from whatever it was before to empty.

 $sqld = "UPDATE mynotes SET notes = 'GOSSAMER' WHERE id = '2039'";
 $resupdate = mysql_query($sqld) or die(mysql_error()); 
 if ($resupdate) {
    $success=1;
    $message .="success with update";
 }

The query is part of an an API and it returns a result in JSON. While this makes debugging more time consuming, this should be besides the point. If the above is an entirely legal update statement, then at least I can rule out a syntax issue and search for the problem elsewhere.

I have verified that the above code does work in a standalone php file. Something else in code is causing the issue.

Yes, mysql is deprecated in favor of mysqli and PDO. But upgrading legacy site is not in job scope.

Upvotes: 0

Views: 59

Answers (1)

symcbean
symcbean

Reputation: 48367

It replaces the existing value with an empty value instead of the word gossamer

Assuming this statement is accurate then either:

1) the attribute 'notes' is of type ENUM whose values do not include 'Gossamer'. But you didn't share the DDL for the table.

2) Your code is not executing the query you've shown us here - the query it is executing should be in your MySQL logs

Upvotes: 1

Related Questions