8 replies to this topic

[Epatron]

<?php

require "koodit/yhteys.php";


if(!mysql_num_rows(mysql_query("SELECT * FROM kayttajat WHERE 

	nimi='".mysql_real_escape_string($nimi1)."' AND 

	salasana='".mysql_real_escape_string(md5($salasana1))."'"))or die (mysql_error())==1) 

{ 

echo "FAIL";

}else{

echo "Kirjauduit!"; 

$_SESSION['nimi'] = $nimi; 

}

?>

What's wrong with this code? Everytime I put 100% right information to form I get FAIL message!! :O
I might be blind because not seeing it, eventough 1st time using md5 :o!

[Vaielab]

What is the error?
Does it die mysql_error or echo fail, or nothing at all?

[Epatron]

Just echo "FAIL" :(!

[Vaielab]

do a var_dump of $nimi1 and md5($salasana1)
do you have thoses data in your databases?

[Epatron]

Yes I have table with id,name,email, and password, could this error be this md5 ? Am I doin something wrong with those?
(PS. tables are in finnish ofcourse ... id,nimi,salasana)

[Vaielab]

Ok, but what about the data in thoses columns, do they exist, and do the password columns is in md5 inside the database?

[Epatron]

In colums? Yes I insert data from form from other page. ? And yes its md5 at database.

[Vaielab]

can you show the result of a select *
and the result of the 2 var_dump

[Epatron]

Don't get what you mean? :O

---------- Post added at 06:58 AM ---------- Previous post was at 06:36 AM ----------

Seriously need help here! :3

---------- Post added at 07:17 AM ---------- Previous post was at 06:58 AM ----------

Omg !!!! The error was so hilarious , I did have char limit ( 30 ) at password ( re-edited it to 255) !!!
Sorry guys for this stupidness :D