methulah

I feel a right fool here, turns out that along with a few password/md5 issues, the real problem was that my column in the database was varchar(12) and the full md5 hash didn't fit. Thanks everyone for your help.

I've now changed it to: AND `password` = '$password' and changed the die($message) to die(mysql_error()); and now it just brings up a blank screen, whereas it ought to redirect me if one row is returned, or bring up an error message if none. Cheers for your help.

$username=$_POST['username']; $unpassword=$_POST['password']; $password=md5($unpassword); dbConnect('delibera_BST'); $sql="SELECT * FROM `users` WHERE username = '$username' AND PASSWORD = '$password'"; $result=mysql_query($sql) or die("NO CAN DO!"); $num = mysql_num_rows($result) or die("NO COUNT!"); if ($num == 1){ This brings up the die("NO COUNT!"); message. Any ideas?