Re: SQL statement in PHP

Matt, Maybe the mistake is at the quotes... Just replace the double quotes inside the select statement by single quotes... Try something like: <snip code> $sql = "select Business_Name,Trading_Details where Business_Type='Consultancy' and Bassingbourn != '0' from Main"; </snip code> ^ ^ ^ ^ 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 = > "Consultancy" and Bassingbourn != "0" from Main"; > > If I remove > > where Business_Type = "Consultancy" and Bassingbourn != "0" > > It work fine, but no variation of the above line works. Am I missing > something really obvious. Please help as I am very quickly becoming bald. > > Matt.