MySQL/PHP - SQL UPDATE statement

[BettyJo50]

Hi. I am trying to update one field in my table in MySQL. I cannot get this field to update. Can someone possibly tell me what is wrong with my SQL statement?

$SQL="UPDATE umcritsurv SET IQ_Use_Q9='$IQ_Use_Q9' WHERE fldAuto='54'";

Thank you!!!

 

[sleipnir214]

What errors is MySQL giving you?

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[BettyJo50]

Well, actually, it doesn't give me any errors. It moves on to the next page as though it has inserted it into my database. But when I look, the info for that field is still blank.

 

[sleipnir214]

Is the program you're using to perform this update query trapping errors?

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[BettyJo50]

I'm sorry!! I'm not sure what you mean by that. (I'm still trying it learn this). Where could I find this?

 

[sleipnir214]

I have no idea. I don't even know what programming language you're using.

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[BettyJo50]

I am using PHP with an Apache server.

 

[sleipnir214]

Then I recommend that you take a look at the online manual page for mysql_query()

That page will tell you what return from mysql_query() to expect when the function returns an error.

It may also be that the query is well-formed, yet simply does not affect any records. If I use a statement like "UPDATE foo SET bar=3 WHERE baz=4" and no records have a column baz containing the value 4, then no records will be updated.

I also have a FAQ in the PHP forum on debugging code: faq434-2999

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[BettyJo50]

Thanks for your help!!!!