Re: SQL statement in PHP

2001-02-16 Thread Gerald L. Clark
Matt Davis wrote: Check the manual. The manual shows where following from. > > Can anybody help with this > > If I put the following statement in PHP my browser tells me that there is an > error on the line. > > //create sql statement > $sql = "select Business_Name,Trading_Details

Re: SQL statement in PHP

2001-02-16 Thread Fred van Engen
On Fri, Feb 16, 2001 at 12:43:15PM -, Matt Davis wrote: > Can anybody help with this > > If I put the following statement in PHP my browser tells me that there is an > error on the line. > > //create sql statement > $sql = "select Business_Name,Trading_Details where Business_Type

RE: SQL statement in PHP

2001-02-16 Thread Jon Haworth
PHP sees the first " of "Consultancy" as being the end of the variable $sql. To get round this, change the " to ' inside the statement (e.g. ...where Business_Type = 'Consultancy' and...) HTH Jon -Original Message- From: Matt Davis [mailto:[EMAIL PROTECTED]] Sent: 16 February 2001 12:

Re: SQL statement in PHP

2001-02-16 Thread Siim Einfeldt aka Itpunk
Take a look at your query once again: "select/../"Consultancy"/.../" You can have "" inside "". The ways to do it, so that it would work: -> use '$somethinghere' instead of "$something" or -> use \"$somethinghere\" instead of second "$something" or -> use '".$somthingh