|
|
Posted by Tim Roberts on 11/14/07 07:19
"Sanders Kaufman" <bucky@kaufman.net> wrote:
>"Toby A Inkster" <usenet200707@tobyinkster.co.uk> wrote:
>> John S. wrote:
>>
>>> $sql = "DROP TABLE IF EXISTS 'products'";
>>> $result = mysql_query($sql,$conn);
>>
>> Single and double quote marks have very specific meanings in SQL. You want
>> to wrap the table name in double quotes, not single.
>
>I was under the impression that square braces were the way to go:
>$sSQL = "DROP TABLE IF EXISTS [products]";
No, that's a Microsoft extension that only works in Access. It isn't SQL.
--
Tim Roberts, timr@probo.com
Providenza & Boekelheide, Inc.
Navigation:
[Reply to this message]
|