Update Question

[creativkook]

Alright, i should know this, but I haven't worked with PHP in awhile, so I'm fuzzy.  I'm trying to go back and have a user recode something, so it updates the fields in the database.  Everything seems to be running fine, but my query isn't working for some reason.  could someone look at it and make sure the sql is correct?  Thanks!

 

mysql_query("UPDATE plaiddata SET loanAmount = '$loanAmount', longDesc = '$longDescription', aidType2 = '$aidType', environAidType2 = '$environAidType', healthImpact2 = '$healthImpact', crs2Code1 = '$crsCode1', crs2Code2 = '$crsCode2', crs2Code3 = '$crsCode3', crs2Code4 = '$crsCode4', crs2Code5 = '$crsCode5', crs2Code6 = '$crsCode6', masterCRS1 = '$masterCRS1', masterCRS2 = '$masterCRS2', masterCRS3 = '$masterCRS3', masterCRS4 = '$masterCRS4', masterCRS5 = '$masterCRS5', masterAidType = '$masterAidType', masterEnvironAidType = '$masterEnvironAidType', masterHealthImpact = '$masterHealthImpact' WHERE plaidDataID = '$_POST[dataID]'");

[Wildbug]

Not working?  What error do you get?

[gluck]

Alright, i should know this, but I haven't worked with PHP in awhile, so I'm fuzzy.  I'm trying to go back and have a user recode something, so it updates the fields in the database.  Everything seems to be running fine, but my query isn't working for some reason.  could someone look at it and make sure the sql is correct?  Thanks!

 

mysql_query("UPDATE plaiddata SET loanAmount = '$loanAmount', longDesc = '$longDescription', aidType2 = '$aidType', environAidType2 = '$environAidType', healthImpact2 = '$healthImpact', crs2Code1 = '$crsCode1', crs2Code2 = '$crsCode2', crs2Code3 = '$crsCode3', crs2Code4 = '$crsCode4', crs2Code5 = '$crsCode5', crs2Code6 = '$crsCode6', masterCRS1 = '$masterCRS1', masterCRS2 = '$masterCRS2', masterCRS3 = '$masterCRS3', masterCRS4 = '$masterCRS4', masterCRS5 = '$masterCRS5', masterAidType = '$masterAidType', masterEnvironAidType = '$masterEnvironAidType', masterHealthImpact = '$masterHealthImpact' WHERE plaidDataID = '$_POST[dataID]'");

 

If I am not wrong then the problem is single quotes. Try using \" instead of single quotes

[fenway]

Show us the mysql query after variable interpolation -- that is, store the query in an $sql variable, and echo that before you execute it.