won't update

[jeff5656]

When i try to update a record, it does not get updated.

 

$qq = "update dos set completed = 'rejected', rejectreason='$rejectreason' where dos_id = '$dosid' LIMIT 1";
mysql_query($qq) or die(mysql_error());

 

the field that is called  "completed" is an enum:

CREATE TABLE IF NOT EXISTS `dos` (

  `dos_id` int(254) NOT NULL AUTO_INCREMENT,

  [...]

  `completed` enum('n','y','rejected') NOT NULL,

etc.

 

So when I try to change the "completed" field to "rejected" it does not update but when i update it to either an "n" or a "y" it works.

 

Does anyone see any problems?  It's weird.  I can also manually change it to "rejected" within phpmyadmin.

 

Also when I echo $qq, the dos_id (and $dosid) is correct, but that record is not being updated.  That record still has a "n" instead of "rejected".

[redarrow]

http://dev.mysql.com/doc/refman/5.0/en/enum.html

 

 

let also check if completed is a reserved name for mysql.

 

http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html

 

 

not seen nothing yet thinking.

[jeff5656]

The other interesting thing is the other field DOES get updated correctly (rejectreason). 

[redarrow]

try with no '<<< acts like a LIKE then see what happens?

$qq = "update dos set completed = rejected, rejectreason='$rejectreason' where dos_id = '$dosid' LIMIT 1";
mysql_query($qq) or die(mysql_error());

 

echo out the input see what happening.

 

echo $qq;

 

 

[Pikachu2000]

I take it you aren't getting any errors, right? If you echo the query string, and paste it in to phpMyAdmin or the MySQL CLI, does it work as it should?

[redarrow]

$ <<<<<<< missing?

 

$ add the >>>rejected

 

 

[jeff5656]

Ok I feel really stupid about this especially with everyone chiming in to help.

That update statement was up at top of the page under an if (isset(_post).

 

right below that was another IF line that was true, containing a query to update completed to n!!  So it WAS updating to "rejected" and then a second query 4 lines down was updating it to "n"! 

Sorry to waste everyone's time LOL!

 

 

[Pikachu2000]

try with no '<<< acts like a LIKE then see what happens?

$qq = "update dos set completed = rejected, rejectreason='$rejectreason' where dos_id = '$dosid' LIMIT 1";
mysql_query($qq) or die(mysql_error());

 

What are you talking about? Removing the quotes from 'rejected' will attempt to set the `completed` field to the value of the `rejected` field if one exists, and has nothing to do with a LIKE comparison.

[redarrow]

try with no '<<< acts like a LIKE then see what happens?

$qq = "update dos set completed = rejected, rejectreason='$rejectreason' where dos_id = '$dosid' LIMIT 1";
mysql_query($qq) or die(mysql_error());

 

 

ok what ever.

 

What are you talking about? Removing the quotes from 'rejected' will attempt to set the `completed` field to the value of the `rejected` field if one exists, and has nothing to do with a LIKE comparison.

[redarrow]

i read it from my notes from site pro maybe there wrong only had to try it...