looks to me like like GLOBAL $company should be partr of the php code, not sql. Tim Ward Senior Systems Engineer Please refer to the following disclaimer in respect of this message: http://www.stivesdirect.com/e-mail-disclaimer.html > -----Original Message----- > From: Jeremy Morano [mailto:[EMAIL PROTECTED]] > Sent: 19 July 2001 16:20 > To: [EMAIL PROTECTED] > Subject: is this right? > > > is this right? > cause its not working. > > > > first I connect, > then I select my db, > > and then the problem > > > $sql = "GLOBAL $company; > DROP TABLE $company "; > $result = @mysql_query($sql,$connection) or die("Couldn't > execute query."); > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]