[SOLVED] Need Guru Help! PHP Login Not Working!!!

[coldfiretech]

Changed that. Getting this though

 

 

 

Parse error: syntax error, unexpected T_VARIABLE in C:\wamp\www\cellsavior\userAuth.php on line 10

 

[cooldude832]

do u have php error reporting on???

try

<?php
$db_host = 'localhost';
$db_user = '****';
$db_pass = '****';
$db_db = '*****';
$con = mysql_connect($db_host, $db_user, $db_pass) or die('MySQl Connection Error:'.mysql_error());
mysql_select_db($db_db, $con) or die('MySQL Error: Cannot select table');

$user = mysql_real_escape_string($_POST['login']);
$password = mysql_real_escape_string($_POST['password']);

$q = "
SELECT 
	login, subtype
FROM `users`
Where
	login = '".$user."' AND 
	password = '".$password."'
";
$r = mysql_query($q,$con) or die(mysql_error()."<br /><br />".$q);
if(mysql_num_rows($r) >0){
$row = mysql_fetch_assoc($r);

switch ($row['subtype']){

	case "single":
		die(header("location: /****/single.php"));
	break;
	case "partner":
		die(header("location: /****/partner.php"));
	break;
	case "family":
		die(header("location: /***/family.php"));
	break;
	default:
		die(header("location: index.html?msg=invalid subtype"));
}
}
else{
die(header("location: index.html?msg=invalid login"));
}
mysql_close ($con);
?>

[coldfiretech]

THANK YOU!@~!!!!!!!!!!!!!  [bows down]

 

I appreciate all of everyones help..

Sorry for being a grump!

[cooldude832]

you have another problem you aren't authenticating the user any where (sessions or cookies) so look at some basic login tutorials and see how to make it better.

[Third_Degree]

At third degree: ppl shouldn't be able to turn it off its very helpful

 

it's annoying though.