<?php
require('variables.php');
$dbHost = "localhost";
$dbUser = "dnl_login";
$dbPass = "login";
$dbDatabase = "dnl_login";

//connect to the database

$db = mysql_connect("$dbHost", "$dbUser", "$dbPass") or die ("Error connecting to database.");

mysql_select_db("$dbDatabase", $db) or die ("Couldn't select the database.");

$result=mysql_query("select * from users where sitename='$sitename'", $db);

//check that at least one row was returned

$rowCheck = mysql_num_rows($result);
//echo $rowCheck;
if($rowCheck > 0){
echo "$sitename already exists!";
exit;
}else{
$sql="INSERT INTO users (sitename, username, package, password, email, fname, lname, address, city, state, zip, phone, altphone, bill_amount, bill_date, bill_freq, paypal, created, storage, bandwidth, referred_by, status) VALUES ('$sitename','$user','$package','$password','$email','$fname','$lname','$address','$city','$state','$zip','$phone','$altphone','$bill_amount','$bill_date','$bill_freq','$paypal','$created','$storage','$bandwidth','$referred_by','$status')";

if (!mysql_query($sql,$db))
  {
  die('Error: ' . mysql_error());
  }
echo "Record added";

}
?>