PHP & MYSQL basic question

maco

I have this code, it's been working before, not sure what happened it could not connect now ! ! !

$user = "user1";
$host = "localhost";
$password = "pass1";
$database = "data1";
$connection = mysql_connect($host,$user,$password)
or die ("Error 1");
$db = mysql_select_db($database, $connection)
or die ("Error2");

$query = "Select email from passfile where email = '$emailkey' and PASSWORD = $pass";
$result = mysql_query($query)
or die ("Error 3");
$num = mysql_num_rows($result);


It display's Error 3. It managed to pass Error 1 & Error 2, but I am sure I have given user 1 proper authority . . .

Anyone, please . . . .

seamus

Use

die("Error 3: ".mysql_error());

This will print out a reason why you got an error.

Sposs

have you change the password on the database without updating your php script?

That's a fairly common reason.But hard to tell without more info.

What error message are you getting?

Seth Brundle

Is there a table called passfile with columns called email and PASSWORD?

maco

Thanks for the replies . . . .
First, i have not changed the password, If I am not wrong it should fail right away in Error 1.

Second, email and PASSWORD are found in PASS file.

I have chage the the error message to ("Error 3: ".mysql_error()); as suggested,

the funny thing is,

if my input is email = 1234 and password = 1234, it works, it shows the proper error saying emial 1234 does not exist

But if my input is email = abcd and password = abcd, it does not works, it shows error 3 with an sql error of Unknown column 'abcd' in 'where clause'

My email setting is 50 varchar, not sure what tot do next . . .

DonkeyStyle \o/

maco wrote:

the funny thing is,

if my input is email = 1234 and password = 1234, it works, it shows the proper error saying emial 1234 does not exist

But if my input is email = abcd and password = abcd, it does not works, it shows error 3 with an sql error of Unknown column 'abcd' in 'where clause'

I'd enclose that $pass in quotes tbh... afaik mysql is alright with int's not having quotes but not chars, which is why you get away with 1234, but not abcd.

maco

spot on !!!

thanks to all of you ..........