On Tue, 7 Aug 2001 01:52, Julian Simpson wrote:
> who's fault is this?:
> 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??
>
You might try using single quotes rather than double quotes to delimit
your string value in the SQL statement.
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
Do vegetarians eat animal crackers?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
