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