Jump to content

Php login register form


Daniel_French

Recommended Posts

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 
Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.