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]

Reply via email to