Thanks Keith, that got me past the first two queries but I'm now getting an " Invalid DATA LOAD query" . Someone told me that the "load data infile option is not always on by default. Is there a piece of code I need to insert earlier in the file to "turn on" the load local file option?
-----Original Message----- From: Keith C. Ivey [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 10:53 AM To: '[EMAIL PROTECTED]' Cc: Montagna, Dan Subject: Re: Load data infile issue On 5 Aug 2003 at 9:37, Montagna, Dan wrote: > $result = mysql_db_query('$sql_id',"DELETE FROM tablename") or die > ("Invalid DELETE query"); It's helpful to print mysql_error() when you have an error, so you get a message more specific than "Invalid DELETE query". In this case, you're trying to delete from a database called '$sql_id' -- that is, a dollar sign followed by 'sql_id'. Presumably that's not your actual database name. Remove the single quotes (so that you're using the *value* of $sql_id) and try again. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]