[PHP-DB] $user=$email

[Addison Ellis]

hello,
i am trying to do the following:
case "login": $connection = mysql_connect($host, $user,$password) //15 or die ("Couldn't connect to server.");
$db = mysql_select_db($database, $connection)
or die ("Couldn't select database.");

$sql = "SELECT email FROM accounts WHERE email='$email'";
$result = mysql_query($sql)
or die("Couldn't execute query.");
$num = mysql_num_rows($result); if ($num == 1) // login name was found //25 {
$sql = "SELECT email FROM accounts WHERE email='$email'
AND password=password('$password')";
$result2 = mysql_query($sql)
or die("Couldn't execute query.");
$num2 = mysql_num_rows($result2);
if ($num2 > 0) // password is correct {
$auth="yes"; //35 $user=$email; $today = date("Y-m-d h:m:s"); $sql = "INSERT INTO login (loginName,loginTime)
VALUES ('$email','$today')";
mysql_query($sql) or die("Can't execute query.");
header("Location: cat_ad.php"); }
else // password is not correct {

in my config.php file which is a required file i have $user=$email, etc.
i continually receive an access denied/couldn't connect to server. i'm sure i'm leaving something out...
thank you for your time. addison
--
Addison Ellis
small independent publishing co.
114 B 29th Avenue North
Nashville, TN 37203
(615) 321-1791
[EMAIL PROTECTED]
[EMAIL PROTECTED]
subsidiaries of small independent publishing co.
[EMAIL PROTECTED]
[EMAIL PROTECTED]