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.
--
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]