Ok I can't seem to get this. Now is it possible to have MySQL on a other computer and run the script. In other words the perl script is on foo.com and MySQL database is on foo2.com. What is need to make the script work. What I have in the script is: Configure.pl sub configure { ######################################## # CGI CONFIGURATION VARIABLES ######################################## $mailprogram = "/usr/sbin/sendmail -t"; $mysqlhost = "mysql.foo2.com 3306"; $mysqldatabase = "matchpro"; $mysqlusername = "username"; $mysqlpassword = "password"; add.pl #!/usr/bin/perl -s use Socket; use DBI; require "configure.pl"; &configure; open (HEADERHTML, "$headerhtml"); @header = <HEADERHTML>; close HEADERHTML; open (FOOTERHTML, "$footerhtml"); @footer = <FOOTERHTML>; close FOOTERHTML; $orderid = &generateorderid; $profilenumber = $orderid; &form_parse; $AdHeadline = $FORM{'AdHeadline'}; $EmailAddress = $FORM{'EmailAddress'}; $TelephoneAreaCode = $FORM{'TelephoneAreaCode'}; $City = $FORM{'City'}; $StateProvince = $FORM{'StateProvince'}; $Zip = $FORM{'Zip'}; $Country = $FORM{'Country'}; $RelationshipPreference = $FORM{'RelationshipPreference'}; $SexualPreference = $FORM{'SexualPreference'}; $Username = $FORM{'Username'}; $Password = $FORM{'Password'}; $VerifyPassword = $FORM{'VerifyPassword'}; $SmokingPreference = $FORM{'SmokingPreference'}; $DrinkingPreference = $FORM{'DrinkingPreference'}; $MaritialStatus = $FORM{'MaritialStatus'}; $HaveChildren = $FORM{'HaveChildren'}; $BodyBuild = $FORM{'BodyBuild'}; $Height = $FORM{'Height'}; $Religion = $FORM{'Religion'}; $Race = $FORM{'Race'}; $AstrologicalSign = $FORM{'AstrologicalSign'}; $Age = $FORM{'Age'}; $Occupation = $FORM{'Occupation'}; $MiscComments = $FORM{'MiscComments'}; $MiscComments =~ s/ /\|/g; $MiscComments =~ s/\s/\|/g; $MiscComments =~ s/\|+/ /g; $dbh = DBI->connect("DBI:mysql:$mysqldatabase", "$mysqlhost","$mysqlusername", "$mysqlpassword") || die("Couldn't connect to database!\n"); print "Content-type: text/html\n\n"; &printheader; &errcheck; &checkuniqueusernames; &checkuniqueemails; &savedata; &printconfirmation; &printfooter; &emailmember; $dbh->disconnect; There is more but the script never gets past $dbh = DBI
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php