Posted by Mwahahahahaaahaa on 12/10/06 02:17

Hello all... I'm always getting these 1064 errors... For example I have
a mySQL dbase that i can connect to fine.. read values etc fine.. but I
want to update a field with different text and it won't work.. I've
tried numerous variations, but here is one of them.

p.s. the vars are as follows:
$globalYear = "2006";
$dayAsWord = "twentythree";
$updatedText = "What I want to insert";
$globalMonth = "dek" // I had "dec" but that was a reserved word so i
changed it.

$theQuery = "UPDATE '{$globalYear}' SET '{$dayAsWord}' =
'{$updatedText}' WHERE 'months' LIKE '{$globalMonth}'";


My table is as Follows:

month | start | days | one | two | etc....
___________________________________
dek | 3 | 31 | | |


If anyone can point me in the right direction on how to avoid the
#1064 errors I would greatly appreciate it!!!!!!!!!!!!!!!!!!!!!! I've
tried removing ' away from certain words and adding to others and no
combination has helped at all... this language is EASY except for this
part, which I don't understand..... Thanks again ahead of time!!!!

[Back to original message]