got the first part figured out now I have another question. Why doesn't it verify the password. If I have the username correct it redirects me nomatter what PW I put in.
heres the sumission form:
<html>
<head>
<title>Login</head>
</HEAD>
<body>
<form action="auth.php" method="post">
User Name: <input type="text" name="name">
Password: <input type="text" name="password">
<input type="submit" value="Login">
</form>
heres the php code
<?php
$conn = mysql_connect("localhost", "xxxxxx", "xxxxxx");
mysql_select_db("fiveohhh_login", $conn);
$uname = $_POST[name];
$sql = "select name from logins where name = '$uname'";
$result = mysql_query($sql) or die (mysql_error());
extract(mysql_fetch_assoc($result));
if ($password == $_POST[password]) {
header ("Location: http://www.jza2000.com/");
} else {
echo "sorry wrong username or password";
}
?>
heres the sumission form:
<html>
<head>
<title>Login</head>
</HEAD>
<body>
<form action="auth.php" method="post">
User Name: <input type="text" name="name">
Password: <input type="text" name="password">
<input type="submit" value="Login">
</form>
heres the php code
<?php
$conn = mysql_connect("localhost", "xxxxxx", "xxxxxx");
mysql_select_db("fiveohhh_login", $conn);
$uname = $_POST[name];
$sql = "select name from logins where name = '$uname'";
$result = mysql_query($sql) or die (mysql_error());
extract(mysql_fetch_assoc($result));
if ($password == $_POST[password]) {
header ("Location: http://www.jza2000.com/");
} else {
echo "sorry wrong username or password";
}
?>