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]
