hjælp til loginok.php plezz
Hey jeg har har lavet set perfekt sys. det enste der ik virker er login.Når jeg prøver at login skriver den det her.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in
/customers/cronic.dk/cronic.dk/httpd.www/loginok.php on line 30
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in
/customers/cronic.dk/cronic.dk/httpd.www/loginok.php on line 52
loginok.php ser sån her ud.
<? include("inc/sql.php"); ?>
<html>
<body bgcolor="#25323D" text="#FFFFFF" leftmargin="0" topmargin="0" rightmargin="0"
bottommargin="0">
<head>
<link rel="stylesheet" href="/base.css" type="text/css">
</head>
<?
$time=time();
$select_chatten = mysql_query("SELECT id FROM users WHERE(username='Chatten')");
$row_chatten = mysql_fetch_array($select_chatten);
$select_chattere = mysql_query("SELECT id,username,rum,answer FROM users WHERE(rum!=0)");
while($row_chattere=mysql_fetch_array($select_chattere)) {
if ($time-$row_chattere[answer] > 180)
{
mysql_query("INSERT INTO chat (rum,text,time,f,t)
VALUES('$row_chattere[rum]','$row_chattere[username] blev smidt ud på grund af
inaktivitet.','$time','$row_chatten[id]','0')");
mysql_query("UPDATE users SET rum='0',onlinechat='0' WHERE(id='$row_chattere[id]')");
}
}
if (!$id) {
$kryppassword=md5($password);
$select_logincheck = mysql_query("SELECT id,kryppassword,room FROM users
WHERE(username='$username')");
$row_logincheck = mysql_fetch_array($select_logincheck);
if ($kryppassword!=$row_logincheck[kryppassword]) {
include("inc/header.php");
print "Forkert brugernavn eller password!";
include("inc/footer.php");
exit;
} else {
if ($login) {
$id=$row_logincheck[id];
session_register(id);
session_register(kryppassword);
$valign="middle";
mysql_query("UPDATE users SET logins=logins+1 WHERE(id='$id')");
include("inc/header2.php");
print "<font size=\"4\"><b><center>Indlæser Brugerprofil...";
include("inc/footer.php");
flush();
print "
<meta http-equiv=\"refresh\" content=\"0;url=loginok.php\">
";
exit;
}
}
}
include("inc/password.php");
$select_info = mysql_query("SELECT username,onlinetid,spir,room,fisk FROM users
WHERE(id='$id')");
$row_info = mysql_fetch_array($select_info);
$select_post = mysql_query("SELECT id FROM post WHERE(modtager='$id' && status='0')");
$select_online_users = mysql_query("SELECT id FROM users WHERE(rum!='0')");
$hour = floor($row_info[onlinetid]/60/60);
$tempmin = $row_info[onlinetid]/60;
$min = floor($tempmin-$hour*60);
if(mysql_num_rows($select_post)>0) {
$read = "<img src=\"gfx/post/letter3.gif\" border=\"0\">";
}
echo "<h½>Velkommen ".$row_info['username']."</h½><br><left><font size=\"1\">";
echo "<a href=\"#\"
onclick=\"window.open('chat/index1.php','looooooool','width=800,height=415,resizable=0,scr
ollbars=1');\">Åben chatten</a><br><br>";
echo "</font></center></font></center>";
;
echo "<b>Coinz: </b>".floor($row_info['spir'])."<br>";
echo "<b>Onlinetid: </b>$hour timer og $min minutter<br>";
echo "<b>Online på chatten: </b>".mysql_num_rows($select_online_users)."<br>";
echo "<br>";
echo " ";
echo " $row_info[info]";
if ($row_info[room] != "0")
{
print "<b>Dit lejligheds Nummer er:</b> ".$row_info['room']."<br>";
}
print "<br>";
?>
</font></body>
</html></SCRIPT>
