i got this error..
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/charmed/public_html/bhs2/edit.php on line 17
can u check for me which variable should i put for "edit.php"
$sql = "SELECT myuser, mypass, myemail, myname, myage, myhobbies FROM ".$db."" or die(mysql_error());
edit.php
$dbserver="127.0.0.1"; // Server to connect to, leave this unchanged
$dbuser="charmed_bhs"; // Username, change this to whatever you need
$dbpass="123"; // Same for pass
$db="charmed_bhs"; // Database name, u need to change this
// End settings
mysql_connect($dbserver,$dbuser,$dbpass);
$sql = "SELECT myuser, mypass, myemail, myname, myage, myhobbies FROM ".$db."" or die(mysql_error());
while ($row = mysql_fetch_array($sql)) {
$Username = $row['username'];
$Password = $row['password'];
$Email = $row['email'];
$Name = $row['name'];
$Age = $row['age'];
$hobbies = $row['hobbies'];
}
?>
<html>
<head>
<title>adad</title>
</head>
<body>
<form method="POST" ACTION="editpro.php">
<p>Username : <input type="text" NAME="username" VALUE =" <? echo $username; ?>" size=35 maxlength=50></p>
<p>Password : <input type="text" NAME="password" VALUE ="<? echo $password; ?>" size=35 maxlength=50></p>
<p>Email : <input type="text" NAME="email" VALUE ="<? echo $myemail; ?>" size=35 maxlength=50></p>
<p>Name : <input type="text" NAME="name" VALUE ="<? echo $name; ?>" size=35 maxlength=50></p>
<p>Age : <input type="text" NAME="age" VALUE ="<? echo $age; ?>" size=35 maxlength=50></p>
<p>Hobbies : <input type="text" NAME="hobbies" VALUE ="<? echo $hobbies; ?>" size=35 maxlength=50></p>
<br><br>
<input type="Submit" name="submit" VALUE="Update Profile"><br><br>
</form>
</body>
</html>
===============================================
register.php
// Global settings, please change these
$dbserver="127.0.0.1"; // Server to connect to, leave this unchanged
$dbuser="charmed_bhs"; // Username, change this to whatever you need
$dbpass="123"; // Same for pass
$db="charmed_bhs"; // Database name, u need to change this
// End settings
if($POST['check']=="Register"){
mysql_connect($dbserver,$dbuser,$dbpass);
mysql_select_db($db);
$SESSION['myuser']=$username;$SESSION['mypass']=$password;$SESSION['myemail']=$email;$SESSION['myname']=$myname;$SESSION['myage']=$age;$_SESSION['myhobbies']=$hobbies;
if (!$username) {echo "<font face=verdana size=2>You did not provide a username!<br></font>"; $signup="no";}
if (!$password) {echo "<font face=verdana size=2>You did not provide a password!<br></font>"; $signup="no";}
if (!$email) {echo "<font face=verdana size=2>You did not provide a email address!<br></font>"; $signup="no";}
if (!$name) {echo "<font face=verdana size=2>You did not enter your name!<br></font>"; $signup="no";}
if (!$age) {echo "<font face=verdana size=2>You did not enter your age!<br></font>"; $signup="no";}
if (!$hobbies) {echo "<font face=verdana size=2>You did not enter your hobbies!</font>"; $signup="no";}
if ($signup=="no"){echo "<font face=verdana size=2><br><br><--<a href=register.php>Go</a> back and try again</font>";}
else {
$query="SELECT * FROM users WHERE username='$username'";
$result=mysql_query($query); $num_rows = mysql_num_rows($result);
if ($num_rows!="0"){mysql_close(); echo "<br><center><font face=verdana size=2>User exists.<br><br>Please go [<a href=./register.php>back</a>] and try again</font></center>";}
else {
mysql_query("INSERT INTO users (Username,Password,Email,Name,Age,Sex,Hobbies) VALUES ( '$username','$password','$email','$name','$age','$sex','$hobbies')"); mysql_close();
echo "<br><br><center><font face=verdana size=2>Username '$username' has been successfully added to our member database.<br>Thank you for verifying as a member of BHS<br></font><br>";}}}
// Form code
else{
echo "<form action=register.php method=post><font face=verdana size=2>Username : </font><input type=text name=username value=$myuser><font face=verdana size=2><br>Password : </font><input type=password name=password value=$mypass><font face=verdana size=2><br>Email : </font><input type=text name=email value=$myemail><font face=verdana size=2><br>Name : </font><input type=text name=name value=$myname><font face=verdana size=2><br>Age : </font><input type=text name=age value=$myage><font face=verdana size=2><br>Sex : </font><select name=sex><option>Male</option><option>Female</option></select><font face=verdana size=2><br>Hobbies : </font><input type=text name=hobbies value=$myhobbies><br><br><input type=submit name=check value=Register><input type=reset value=Reset name=reset></form>";}
?>
===============================================
member.php
$dbserver="127.0.0.1"; // Server to connect to, leave this unchanged
$dbuser="charmed_bhs"; // Username, change this to whatever you need
$dbpass="123"; // Same for pass
$db="charmed_bhs"; // Database name, u need to change this
// End settings
mysql_connect($dbserver,$dbuser,$dbpass);
mysql_select_db($db);
$query="SELECT * FROM users"; $result=mysql_query($query);
$num_rows = mysql_num_rows($result);
for($i=0;$i<$num_rows;$i++){
$users[$i]=mysql_result($result, $i, "username");}
sort ($users);
reset ($users);
while (list ($key,$val) = each ($users)) {echo "<font face=verdana size=2><a href=view.php?user=$val>$val</a><br></font>";}
mysql_close();
?>
===============================================
view.php
$dbserver="127.0.0.1"; // Server to connect to, leave this unchanged
$dbuser="charmed_bhs"; // Username, change this to whatever you need
$dbpass="123"; // Same for pass
$db="charmed_bhs"; // Database name, u need to change this
// End settings
mysql_connect($dbserver,$dbuser,$dbpass);
mysql_select_db($db);
if (!$user) {echo "<br>No user specified<br><br>";}
else{
$query="SELECT * FROM users WHERE username='$user'"; $result=mysql_query($query);
$user=mysql_result($result, 0, "username"); echo "<br><b><center><font face=verdana size=2>Viewing Profile of $user</center><br></b>Username : $user<br></font>";
$email=mysql_result($result, 0, "email"); echo "<font face=verdana size=2>Email : <a href=mailto email>$email</a><br></font>";
$name=mysql_result($result, 0, "name"); echo "<font face=verdana size=2>Name : $name<br></font>";
$age=mysql_result($result, 0, "age"); echo "<font face=verdana size=2>Age : $age<br></font>";
$sex=mysql_result($result, 0, "sex"); echo "<font face=verdana size=2>Sex : $sex<br></font>";
$hobbies=mysql_result($result, 0, "hobbies"); echo "<font face=verdana size=2>Hobbies : $hobbies<p></font>";
mysql_close();
echo"<font face=verdana size=2><a href=member.php>Back to members page</a></font>";}
?>
login.php
$dbserver="127.0.0.1"; // Server to connect to, leave this unchanged
$dbuser="charmed_bhs"; // Username, change this to whatever you need
$dbpass="123 // Same for pass
$db="charmed_bhs"; // Database name, u need to change this
// End settings
if($POST['check']=="Login"){
if(!$POST['username']) {echo "You did not enter a <b>username</b><br>"; $signup="no";}
if(!$POST['password']) {echo "You did not enter a <b>password</b><br>"; $signup="no";}
if ($signup=="no"){echo "Please go [<a href=./login.php>back</a>] and try again";}
else{
mysql_connect($dbserver,$dbuser,$dbpass);
mysql_select_db($db);
$query="SELECT * FROM users WHERE password='$password' AND username='$username'";
$result=mysql_query($query); $num_rows = mysql_num_rows($result); mysql_close();
if ($num_rows!="0"){$SESSION['username']=$POST['username'];$SESSION['password']=$_POST['password'];echo "<br><font face=verdana size=2><center>You are now login.<br><br> Click [<a href=index.php>here</a>] to continue.<br><bR>";}
else {echo "<br><center>Wrong username/password<br><br>Please go [<a href=./login.php>back</a>] and try again</font></center>";}}}
else {
echo "<br><form action=login.php method=post>
<font face=Verdana size=2>Username :<input type=text name=username>
Password :<input type=password name=password>
<input type=submit name=check value=Login><br><br></font>";}
?>
