query returns empty

matumba

hi I want use following script for users login, but by some reason mysql query returns empty and I througth user exist it can't login
eny ideas?
I have tryed to echo values, but there is no data in $info ... why is that?

query

$sql = "SELECT mobile,pwd
	 FROM customer 
	 WHERE mobile = '".$_POST['mobile']."'";
         $check = mysql_query( $sql ) or die( mysql_error() . '<br>' . $sql );
          $info = mysql_fetch_row(  $check  );

and I check posted values

	if (  $_POST['mobile'] != $info['mobile'] ) {
		die( 'wrong login number.' );
	}
	if (  $_POST['pwd'] != $info['pwd'] ) {
		die( 'Wrong password.' );
	}

matumba

well fixed this, but still having rpoblem with md5 encrypted paswrods, becouse they don't match by last 2 numbers..

harmor

when I make the field for the password I make it "40" so I know the whole md5 string will insert into the database without cutting it off.
So look into that.

matumba

harmor wrote:
when I make the field for the password I make it "40" so I know the whole md5 string will insert into the database without cutting it off.
So look into that.

thanx!
I figuret out that it was the case.. hehe oh do I fell silly?!.. :p
what is the max length of md5? is there are way to calculate it?

toplay

md5() will always return 32 characters long in PHP4. The sha1() function returns 40 characters in PHP4.

http://us2.php.net/manual/en/function.md5.php

http://us2.php.net/manual/en/function.sha1.php

🙂