Php login register form

[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 

[jazzman1]

Is "sanitize" an internal ( built-in) function in php?