Php MySQL Error
Posted: Mon Jan 02, 2006 3:35 am
This is code i have made for a messenger part of my site but every time i try to load the page i get this error
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/clive91/public_html/messenger/index.php on line 44
Code: Select all
<?php
$first = $_GET['first'];
if($first == true)
{
$msg = "<font face=\"Arial\"><form method=\"post\" action=\"index.php\">";
$msg.= "<center>";
$msg.= "<table>";
$msg.="<tr>";
$msg.="<td colspan=\"2\"><b>Please Sign In With Your www.ClivesDen.com Username & Password</b></td>";
$msg.="</tr>";
$msg.= "<tr>";
$msg.= "<td align=\"right\">Username: </td>";
$msg.= "<td><input type=\"text\" name=\"username\"></td>";
$msg.= "</tr>";
$msg.= "<tr>";
$msg.= "<td align=\"right\">Password: </td>";
$msg.= "<td><input type=\"password\" name=\"password\"></td>";
$msg.= "</tr>";
$msg.= "<tr>";
$msg.= "<td></td>";
$msg.= "<td><input type=\"submit\" value=\"Log-In!\"></td>";
$msg.= "</tr>";
$msg.= "</table>";
$msg.= "</center></font>";
}
else
{
if(isset($_COOKIE["loggedin"]))
{
$username = $_COOKIE['username'];
mysql_connect ("localhost", "clive91_admin", "jvcfjmr") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("clive91_messenger");
mysql_query("INSERT INTO logged (Username) VALUES (\"$username\")");
$friends = mysql_query("SELECT * FROM friends WHERE Username=\"$username\"");
$friend = "<table width=\"100%\">";
while($row = mysql_fetch_array($friends))
{
$online = mysql_query("SELECT * FROM logged WHERE Username=\"$username\" AND Friend=\"".$row['friend']."\"");
$checking = mysql_num_rows($online);
if($checking < 1)
{
$friend.= "<tr><td align=\"center\">".$row["Friend"]."</td></tr>";
}
else
{
$friend.= "<tr><td align=\"center\">Online".$row['Friend']."</td></tr>";
}
}
$friend.= "<tr><td align=\"center\"><a href=\"newfriend.php\">Add New Friend</a></td></tr></table>";
mysql_select_db("clive91_Users");
$emaila = mysql_query("SELECT * FROM users WHERE Username=\"$username\"");
$info = "<table width=\"100%\" valign=\"top\">";
$info.= "<tr valign=\"top\"><td align=\"left\">Username: $username</td>";
while($rows = mysql_fetch_array($emaila))
{
$info.= "<td align=\"left\">E-Mail Address: ".$rows['Email']."</td></tr>";
}
$msg = "<font face=\"Arial\"><table width=\"100%\">";
$msg.= "<tr>";
$msg.= "<td colspan=\"2\"><h3><center>$username</center></h3></td>";
$msg.= "</tr>";
$msg.= "<tr>";
$msg.= "<td width=\"30%\"><center><h4>Contacts</h4></center></td><td><center><h4>User Info</h4></center></td>";
$msg.= "</tr>";
$msg.= "<tr>";
$msg.= "<td>$friend</td><td>$info</td>";
$msg.="</tr>";
$msg.= "</table></font>";
}
else
{
$username = $_POST['username'];
$password = $_POST['password'];
if(!$username || !$password)
{
$msg = "<font face=\"Arial\"><form method=\"post\" action=\"index.php\">";
$msg.= "<center>";
$msg.= "<table>";
$msg.="<tr>";
$msg.="<td colspan=\"2\"><b>Please Sign In With Your www.ClivesDen.com Username & Password</b></td>";
$msg.="</tr>";
$msg.= "<tr>";
$msg.= "<td align=\"right\">Username: </td>";
$msg.= "<td><input type=\"text\" name=\"username\"></td>";
$msg.= "</tr>";
$msg.= "<tr>";
$msg.= "<td align=\"right\">Password: </td>";
$msg.= "<td><input type=\"password\" name=\"password\"></td>";
$msg.= "</tr>";
$msg.= "<tr>";
$msg.= "<td></td>";
$msg.= "<td><input type=\"submit\" value=\"Log-In!\"></td>";
$msg.= "</tr>";
$msg.= "</table>";
$msg.= "</center></font>";
}
else
{
mysql_connect("localhost","clive91_admin","jvcfjmr") or die("Database Error Please Contact The Administrator");
mysql_select_db("clive91_Users");
$result = mysql_query("SELECT * FROM users WHERE Username = \"$username\" and Password = \"$password\"");
$num_rows = mysql_num_rows($result);
if($num_rows < 1)
{
$msg = "<font face=\"Arial\"><form method=\"post\" action=\"index.php\">";
$msg.= "<center>";
$msg.= "<table>";
$msg.="<tr>";
$msg.="<td colspan=\"2\"><b>Please Sign In With Your www.ClivesDen.com Username & Password</b></td>";
$msg.="</tr>";
$msg.= "<tr>";
$msg.= "<td align=\"right\">Username: </td>";
$msg.= "<td><input type=\"text\" name=\"username\"></td>";
$msg.= "</tr>";
$msg.= "<tr>";
$msg.= "<td align=\"right\">Password: </td>";
$msg.= "<td><input type=\"password\" name=\"password\"></td>";
$msg.= "</tr>";
$msg.= "<tr>";
$msg.= "<td></td>";
$msg.= "<td><input type=\"submit\" value=\"Log-In!\"></td>";
$msg.= "</tr>";
$msg.= "</table>";
$msg.= "</center></font>";
}
else
{
$msg = "Log-In Sucssesful";
setcookie("loggedin","true", time()+600000);
setcookie("username",$username, time()+600000);
header("Location:index.php");
exit();
}
}
}
}
?>
<html>
<body background="bg.gif">
<?php echo($msg); ?>
</body>
</html>