Incorrect integer value when updating field in mysql table

Question

I am having an issue with a defined integer when updating a row in mysql.

More precisely:- I am entering 2 as the field value, and when I go to view the row, the field is set to 1.

Here is my SQL command:

$DB->query("UPDATE Listings SET Type='2' AND Status='Available' WHERE LID='$LID'");

The query itself executes fine, the value is updated and the correct row is chosen. It is the 'Type' field that is the problem. The field type is tinyint.

Totally stumped here, please help!

Edit: Please note the passing of variables in this manner can allow for SQL Injection. NOT RECOMMENDED

Have you tried other data types to see if the behavior is the same? — N1tr0
– N1tr0, Commented Jan 30, 2013 at 19:56

Roozbeh Zabihollahi · Accepted Answer · 2013-01-30 19:57:34Z

7

The Query should be written like this:

UPDATE Listings SET Type='2', Status='Available' WHERE LID='$LID'

answered Jan 30, 2013 at 19:57

Roozbeh Zabihollahi

7,35748 silver badges39 bronze badges

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

2 Comments

Gordon Linoff Over a year ago

+1 . . . As a general rule, when a question says that an update is not working, it is because there is a syntax error in the code.

Mike GB Over a year ago

As often is the case, it's a simple syntax error causing the problems! Thanks for your help @Roozbeh

Collectives™ on Stack Overflow

Incorrect integer value when updating field in mysql table

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related