Login Script help not returning the echo statement

Hello i made a php login script there is no errors but it will not return the echo"Logged in" plz help here is the code

<?php $con = mysqli_connect('localhost','root','','prankvsprank'); if (mysqli_connect_errno()){ echo"Failed to connect_2" . mysqli_connect_error(); }else echo" Connected To Database_2"; $lUsername = @$_POST['lUsername']; $lPassword = @$_POST['lPasssword']; $lSubmit = @$_POST['lsubmit']; if($lSubmit==TRUE){ if($lUsername==TRUE){ if($lPassword==TRUE){ $login = ("SELECT * FROM prankvsprank WHERE username = '$lUsername' AND password = '$lPassword'")or die(mysqli_error_list()); $res = mysqli_query($login); $count = mysqli_num_rows($res); if($count==1){ echo"Logged in"; }else echo"Error_2"; } } } ?> Login Login
Username:
Password:

Kinda newish to MYSQL myself so I may be way off base but I try to practice putting variable like this:

(“SELECT * FROM prankvsprank WHERE username = '”.$lUsername."’ AND password = ‘".$lPassword."’")

Sponsor our Newsletter | Privacy Policy | Terms of Service