我有一个PHP代码，在执行时给出错误。 任何人都可以指出我的错误。

Question

This is my code.

<?php
require "conn.php";
$user_name = "un";
$user_pass="123";  
$mysql_qry ="select * from user where username like '$user_name' and main_password '$user_pass';";
$result = mysql_query($mysql_qry, $conn);

if(mysql_num_rows($result)>0){
    echo "Login Success!";
}else{
    echo "Invalid Username or Password!";
}

?>

Error message is attached herewith. enter image description here

Answer 1

Please check your $result if it returns false and check your query error.

$result=mysql_query($sql);
if ($result==false)
{
    die(mysql_error());
}
else
{
    echo "Login Access";
}