>> 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 helps....In 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 it....In 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
