Help!!
I have found a script but I cannot get it to work?
Do the error messages mean anything to you? Does the PHP script look ok?
Error Logs>
[Tue Mar 29 22:42:18 2005] [error] PHP Notice: Undefined variable: name in c:\Apache\htdocs\myinvoice\login.php on line 6
[Tue Mar 29 22:42:18 2005] [error] PHP Notice: Undefined variable: password in c:\Apache\htdocs\myinvoice\login.php on line 7
<?
include("inc/config.php");
$conn = @mysql_connect("localhost", "rcox", "joshua") or die
("Unable to connect!");
$result = @mysql_select_db( "rates", $conn )
or die( "Could not select database" );
$sql="select * from clients where name = '" . $name . "'
and password = '". $password . "'";
$result = mysql_query($sql, $conn)
or die(mysql_error() ."Could not execute query" );
if (mysql_num_rows($result) == 1)
{
session_start();
session_register("client_id");
session_register("client_name");
session_register("client_email");
session_register("client_ref");
session_register("client_title");
list($clientid, $name, $pass, $email, $ref, $title) =
mysql_fetch_row($result);
$client_id = $clientid;
$client_name = $name;
$client_email = $email;
$client_ref = $ref;
$client_title = $title;
header("Location: menu.php");
mysql_free_result ($result);
mysql_close($conn);
}
else
{
mysql_free_result ($result);
mysql_close($conn);
header("Location: index.htm");
exit;
}
?>
