HI
I'M MAKING SMALL PROJECT AND I HAVE SOME PROBLEM WITH MY PROJECT
THAT I WANT TO KNOW IF USER IN DATABASE AND IF THE USER IS IS
THE PHP PRINT SUCCESS MESSAGE AND GIVE ME INFO ABOUT THE USE
HERE MY CODING
<?php
include("./db.php");
$link = mysql_connect($server, $user, $pass);
if(!mysql_select_db($database)) die(mysql_error());
$result = mysql_query("SELECT * FROM `members`");
$r = mysql_fetch_array($result);
$username = $r['username'];
$password = $r['password'];
$email = $r['email'];
//$keya=md5($_GET["key"]);
if (isset($_GET["key"])) {
$key = $_GET["key"];
$q = "SELECT username FROM `members` WHERE (username = '$key')";
if(!($result_set = mysql_query($q))) die(mysql_error());
$number = mysql_num_rows($result_set);
if ($number) {
print "USER FOUND !";
print "</br>";
print "Mr $username";
print "</br>";
print $password;
print "</br>";
print $email;
}
else {
print "Sorry ! User Not Found ";
}
}
?>
AND THE SQL IS IN ATTACH