|
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!!!!
Navigation:
[Reply to this message]
|