Re: myPhpAdmin/mysql/php/ Problem

I've tried every combination of single and or double qoutes i can think of. I don't thats it. thanx though David Robley wrote: > 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?