Query failed

[rainprop]

hi,

when i try to preview the page, this message appears. how do i solve it?

is there any mistake in the input of the codings?

basically i just copied the codings from the internet. but there are some chnges that i did. i duno which one is rite or wrong.

 

$qry="SELECT * FROM `user` WHERE login='login' AND password='".md5($_POST['password'])."'";

$result=mysql_query($qry);

 

if($result) {

if(mysql_num_rows($result) == 1) {

//Login Successful

session_regenerate_id();

$member = mysql_fetch_assoc($result);

$_SESSION['SESS_USER_ID'] = $member['user_id'];

$_SESSION['SESS_EMP_NAME'] = $member['emp_name'];

session_write_close();

header("location: member-index.php");

exit();

}else {

//Login failed

header("location: login-failed.php");

exit();

}

}else {

die("Query failed");

}

?>

[aeroswat]

Copied from the internet >< Is this assignment that you are working on due tomorrow? And how long have you had to complete this?

[PFMaBiSmAd]

If you echo mysql_error() as part of your error checking and error reporting logic, it will tell you why the query failed.

 

I'll guess that it is unlikely you have a column named login and the query failed because of that.

[rainprop]

SORRY...pls don mistake me...the assignment is not due tomorrow..

it has still got 3 weeks left.

but as im redoing it, i tend to have a lot of problem.previously i used the dreamweaver to create the designs where it has helped me to generate the php codings by itself, but now im trying to generate the design woth the php codings..

[rainprop]

thanks aeroswat, and PFMaBiSmAd, i already knew where my mistake is...just found it. thanks again.