Help would be appreciated, When I try to run this Php install script I get the following error “Table 'camrose.devbg' doesn't exist”
The script is supposed to setup the db and the tables but it just returns the above error. The require connection to the mysql dB works. It appears to be some syntax error I can’t figure out. Anyone see it.

bman

<? 
require("conn.php"); 

$q1 = "DROP TABLE IF EXISTS dd_newsletter"; 
mysql_query($q1) or die(mysql_error()." at line ". __LINE__); 

$q1 = "CREATE TABLE dd_newsletter ( 
nemail varchar(150) NOT NULL default '', 
PRIMARY KEY (nemail)) "; 
mysql_query($q1) or die(mysql_error()." at line ". __LINE__);

Explain the situation.
There is no error in this code. Maybe u have an error in conn.php file?

The connection works I check it some how I get the “Table 'camrose.devbg' doesn't exist” error I call it a error because it will not perform the task., it just spits out the above.

First of all find where your script uses this table 'camrose.devbg'. Than put here this extract.

You obviously have something wrong with your connection as the above error has nothing to do with the code that you have posted.

You are right. I have a require request that was executing the connection correctly, but I added code to it for reinstalling at the bottom of the file and it was make request from the db for things that have not been created yet.

Thanks for the help anyway.