MySQL Forums
Forum List  »  PHP

Small errors...
Posted by: Simon Piggott
Date: April 29, 2005 04:18PM

this folie give me grief on line 63. i get the following message:
"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/sime388/public_html/PaperPHP/html/header.php on line 63"


here is the file:

<?
//$sitetitlem = $sitetitle;
//if(ereg("boards",$PHP_SELF))
//{
//$sitetitlem .= ' - Boards ';
//}
if(ereg("pm",$PHP_SELF))
{
$sitetitlem .= ' - Private Messages ';

}
if(ereg("news",$PHP_SELF))
{
$sitetitlem .= ' - News ';

}
if(ereg("signup",$PHP_SELF))
{
$sitetitlem .= ' - Register ';

}
if(ereg("login",$PHP_SELF))
{
$sitetitlem .= ' - Login ';

}
if(ereg("loggedin",$PHP_SELF))
{
$sitetitlem .= ' - Loggedin ';

}
if(ereg("admin",$PHP_SELF))
{
$sitetitlem .= ' - Admin';

}
if(ereg("account",$PHP_SELF))
{
$sitetitlem .= ' - Account';

}
if(ereg("statistics",$PHP_SELF))
{
$sitetitlem .= ' - Statistics';

}
if(ereg("loggedout",$PHP_SELF))
{
$sitetitlem .= ' - Logged Out';
}
if(ereg("lostpw",$PHP_SELF))
{
$sitetitlem .= ' - Lost Password';
}

print("
<!DOCTYPE html PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN'>
<html>
<head>
<title>$sitetitlem</title>
");
$select = mysql_query("SELECT * FROM users WHERE username = '$_COOKIE[username]'");
$row = mysql_fetch_array($select);

if($_COOKIE[username] AND $_COOKIE[password])
{
if($row[style])
{
print("<LINK href='$siteurl/html/themes/$row[style].css' type='text/css' rel=stylesheet>");
}
else
{
print("<LINK href='$siteurl/html/themes/emerald_night.css' type='text/css' rel=stylesheet>");
}
}
else
{
print("<LINK href='$siteurl/html/themes/emerald_night.css' type='text/css' rel=stylesheet>");
}
print("
</head>
<body>
<table border='0' cellspacing='0' cellpadding='1' width='100%'>
<tr>
<td>
<center><font face=verdana size=4 color=lime>$sitename</font></center>
</td>

</tr>
</table>

<table border='0' cellspacing='0' cellpadding='1'>
<tr>
<td valign='top' width='175'><br>
<table cellspacing='0' cellpadding='2' class='all' width='100%'
align='center'>
<tr>
<td></td>
</tr>
");
include("$sitepath/ ");
?>


also, line 101 screws me about, can someone have have a look and pleas help me out :) cheers

Options: ReplyQuote


Subject
Written By
Posted
Small errors...
April 29, 2005 04:18PM
April 30, 2005 12:45AM
April 30, 2005 01:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.