On Tue, Jul 30, 2002 at 07:05:05AM -0700, Paul wrote:
> 1. The following PHP statement:
>
> $strSQL = sprintf("INSERT INTO companies (comp_name, type_id) VALUES
> ('%s', %s);",$strCompName,trim($intTypeID));
>
> yields the SQL statement:
>
> INSERT INTO companies (comp_name, type_id) VALUES ('someName',9);
Is that what your logs tell you it's yielding? Given your errors, my
bet is that PHP is doing something you don't think it is.
> 2. When I try to drop old databases or tables, it gives an error
> telling me that a user is using the database and can't drop the
> table/database. I've even tried it after killing all processes on the
> server and not being logged into the database I'm trying to drop
> (i.e., logged into another database)
Are you sure there's no-one connected? You've checked with ps?
Sounds like a connection isn't really dead.
A
--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M6K 3E3
+1 416 646 3304 x110