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]