having trouble with a mysql query
- by chuck akers
this keeps saying
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in directory here
the error is near the login_query variable, can someone help me fix it.
<?php
if (isset($_POST['login_username'], $_POST['login_password'])) {
$login_username = trim(mysql_real_escape_string(htmlentities($_POST['login_username'])));
$login_password = md5(trim(mysql_real_escape_string(htmlentities($_POST['login_password']))));
if (!empty($login_username) && !empty($login_password)) {
$login_query = mysql_query("SELECT user_id FROM username WHERE username='".$login_username."' AND password='".$login_password."'");
if (mysql_num_rows($login_query)==1) {
$user_id = mysql_result($login_query, 0, 'user_id');
$_SESSION['user_id'] = $user_id;
header('Location: index.php');
die();
}
}}
?
