Re: [PHP-DB] Working query not able to run with PHP script.

2003-09-19 Thread CPT John W. Holmes
From: Jonathan Villa [EMAIL PROTECTED] I have several tables I want to delete as well as their reference in another database The query produced is this: === DROP TABLE xxx.zorder_47629403705b7e7f0c97387559d8c811;

Re: [PHP-DB] Working query not able to run with PHP script.

2003-09-19 Thread Sean Burlington
Jonathan Villa wrote: Sorry, I meant referenced in another table not database On Thu, 2003-09-18 at 16:09, Jonathan Villa wrote: I have several tables I want to delete as well as their reference in another database The query produced is this:

Re: [PHP-DB] Working query not able to run with PHP script.

2003-09-18 Thread Jonathan Villa
Sorry, I meant referenced in another table not database On Thu, 2003-09-18 at 16:09, Jonathan Villa wrote: I have several tables I want to delete as well as their reference in another database The query produced is this:

Re: [PHP-DB] Working query not able to run with PHP script.

2003-09-18 Thread Micah Stevens
Try putting backticks around the table name in the drop table statement. Is xxx the database name? -Micah On Thu September 18 2003 2:09 pm, Jonathan Villa wrote: I have several tables I want to delete as well as their reference in another database The query produced is this: