Daniel_French

Hello, i got a problem with a part of my code : <?php // #1 function user_exists ($username) { $username = sanitize ($username); $query = mysql_query ("SELECT COUNT (user_id) FROM user WHERE username = '$username'"); return (mysql_result($query, 0) == 1) ? true : false; } function user_active($username) { $username = sanitize($username); return (mysql_result( mysql_query("SELECT COUNT(`user_id`) FROM `user` WHERE `username` ='$username' AND `active` = 1 "), 0) == 1) ? true : false; } ?> Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\login\core\functions\users.php on line 9 this is the error i get ... i am building this based on a login & register tutorial on youtube but i did it the same way he did it and told how to ... i did let the code run through a php valdation check and it told me that mysql_query and mysql_result were outdated code ?! just need help thanks alot

Hello, i got a problem with a part of my code : <?php // #1 function user_exists ($username) { $username = sanitize ($username); $query = mysql_query ("SELECT COUNT (user_id) FROM user WHERE username = '$username'"); return (mysql_result($query, 0) == 1) ? true : false; } function user_active($username) { $username = sanitize($username); return (mysql_result( mysql_query("SELECT COUNT(`user_id`) FROM `user` WHERE `username` ='$username' AND `active` = 1 "), 0) == 1) ? true : false; } ?> Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\login\core\functions\users.php on line 9 this is the error i get ... i am building this based on a login & register tutorial on youtube but i did it the same way he did it and told how to ... i did let the code run through a php valdation check and it told me that mysql_query and mysql_result were outdated code ?! just need help thanks alot