I have a problem updating a mysql table entry. I copied and pasted the format I've used for years to update tables, but for some reason it is not working here.
My query reads, $queryUpdate1=mysql_query("UPDATE material SET _3Quan = '$_3Quan' WHERE file='$file'") or die('Query failed1: '.mysql_error());
The variable $_3Quan has a value of 100, but when the material table is updated, it returns a value of 0 to the _3Quan field. Prior to update the value was 95.
Can you help me figure out what I'm doing wrong here?