Re: Problem with UPDATE statement
>> In what way is it mangling my query? >> and why won't the same query work from my php script. >> I would accept this if it was just any interface but myphpadmin is supposed to be >in line with mysql standards. >> >> >> update cdrequest set albumfill = "hot shots II", releasedatefill >> >> = 20010708 where requstID = 2; >> >> >> >> i get: >> >> You have an error in your SQL syntax near '\"hot shots II\", >> >> releasedatefill = 20010708 where requstID = 2' at line 1 >> >> I can't see any reason for the error. >> > >> >Your web based interface is mangling your query. > >Hi Julian. I'd recommend taking the suggestion and try the >query through the command-line interface. If it works there, then >you've isolated the problem to the interface you're using. Divide >and conquer. At this point I don't have telnet access on my host so I'm down to using scripts and myphpadmin. I've made a request to get telnet access and I'll let you know if command line helpsIn the meantime I'm going to try whatever mysql interfaces i can get my hands on. But it's my php script that Is the main problem. Even If command line does what it should and responds accordingly to a normal insert statement. It still doesn't help me to use it where i need itIn my code > >BTW, should requstID be requestID? Fortunately this was a typo i made only for the benefit of this group. rest assured I haven't been testing with a misspelled column name :) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem with UPDATE statement
In what way is it mangling my query? and why won't the same query work from my php script. I would accept this if it was just any interface but myphpadmin is supposed to be in line with mysql standards. >> update cdrequest set albumfill = "hot shots II", releasedatefill >> = 20010708 where requstID = 2; >> >> i get: >> You have an error in your SQL syntax near '\"hot shots II\", >> releasedatefill = 20010708 where requstID = 2' at line 1 >> I can't see any reason for the error. > >Your web based interface is mangling your query. > >> part 2: >> when I flip to properties for the cdrequest just to make sure i'm >> spelling the columns corectly and cut and paste the >> exact same query on that page IT WORKS >> Why would it work on that page but not the other. both are >> supposed to be places where you can enter a normal sql >> query.. > >Because your web based interface is mangling your query. Try using the mysql >command line client. > >> It also doesn't work in my PHP script which is where I really >> want it to work. > >Paste source. > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with UPDATE statement
I have a table 'cdrequest' it has columns 'albumfill' and 'releasedatefill' among others when i do the following query with myphpadmin update cdrequest set albumfill = "hot shots II", releasedatefill = 20010708 where requstID = 2; i get: You have an error in your SQL syntax near '\"hot shots II\", releasedatefill = 20010708 where requstID = 2' at line 1 I can't see any reason for the error. part 2: when I flip to properties for the cdrequest just to make sure i'm spelling the columns corectly and cut and paste the exact same query on that page IT WORKS Why would it work on that page but not the other. both are supposed to be places where you can enter a normal sql query.. It also doesn't work in my PHP script which is where I really want it to work. What am I missing?? thanx Julian btw. I've tried all different combinations of double quotes and single quotes so it's not that - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
