Re: [DB] Problem with DELETE TABLE

Marco Schuler wrote:

Hi Am Mo, 2004-03-08 um 21.11 schrieb Lorenzo Alberton:

On Mon, 08 Mar 2004 20:54:48 +0100, Marco Schuler wrote:

Hi I have this code to process with an easy sql-statement: $sql = 'DELETE TABLE users';

try with "DELETE FROM users" if you want to empty the table, or with "DROP TABLE users" if you want to remove the table

Oops, that was a copy-past-error! I was trying something different and coppied the wrong line. "DELETE FROM users" does not work too. :-( ErrMsg: DB Error: syntax error UsrMsg: 'DELETE FROM users' [nativecode=1064 ** You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''DELETE FROM users'' at line 1] Any hints?

Hmmm try removing the quote() stuff :) Moritz