Codezwiz >> Forums >> General PHP Nuke Help >> non phpnuke script

OK, i am creating a newsletter mailer, and right now i am trying to make the install file. well, when i try to connect, the script dies. I have the connection variables stored in a config file, is thats whats wrong? the script is below. i am following my webhosts settings to a T.

<?php
//install.php
//Part of Newsletter Mailer 1.0
//For support, visit [ Register or login to view links on this board. ]

include("config.php");
if(mysql_connect("$dbhost", "$dbuser", "$dbpass"));
die("Failed to connect to MySQL.");
if(!mysql_create_db("newsletter_db", $link_id))
die("Failed to create the database newsletter_db.");
if(!mysql_query("CREATE TABLE email_add"))
die("Failed to create the table email_add.");
echo "Installation complete! Please delete this install file.";
?>

Where is the actual connection? Above you have a if connection doesnt work but no connection.

$connect = mysql_connect('localhost','user','pass');
if(!mysql_connect("$dbhost", "$dbuser", "$dbpass"));
die("Failed to connect to MySQL.");

ok, ill try that, since there was no initial connect command, it is probably dieing

as i was changing the script, i found some missing semicolons too

I LOVE CZ!!!! If it wasnt for u guys, it probably would have taken forever to finish my install script.

ok, it is now able to connect
new problem-
it now cannot create the table "newsletter_db"

<?php
//install.php
//Part of Newsletter Mailer 1.0
//For support, visit [ Register or login to view links on this board. ]

include("config.php");
$link_id = mysql_connect("$dbhost", "$dbuser", "$dbpass");
if(!mysql_connect("$dbhost", "$dbuser", "$dbpass"))
   die("Failed to connect to MySQL.");
$new_db = mysql_create_db("newsletter_db", $link_id);
if(!mysql_create_db("newsletter_db", $link_id))
   die("Failed to create the database newsletter_db.");
$new_table = mysql_query("CREATE TABLE email_add");
if(!mysql_query("CREATE TABLE email_add"))
   die("Failed to create the table email_add.");
echo "Installation complete! Please delete this install file.";
?>

problem server-specific, thx for all ur help