lil help...??

Sime388

Im having a few problems with a page at the moment, i didnt write this page, it came with some PHP software - i cannot get it sorted and its not starting to annoy me and a lot of others, wonder if anyone could kindly help!?

Im gettin the following error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/sime388/public_html/PaperPHP/index.php on line 80
But on multiple lines.

Here is the code for the page:

<?
print("
<tr>
<th>Main</th>
</tr>

<tr>
<td>
<table cellspacing='0' cellpadding='0' border='0' width='100%'>
<tr>
<td width='50%' nowrap>
        <a href='index.php'>Home</a><br>");
if($_COOKIE[username] AND $_COOKIE[password])
{
$date = date(U);
$update = mysql_query("UPDATE users SET lastlogin = '$date' WHERE username = '$_COOKIE[username]'");
print("
        <a href='news.php'>News</a><br>
        <a href='statistics.php'>Statistics</a><br>

");
}
print("
</td>
</tr>
</table>
</td>
</tr>
</table>

<br>


<table cellspacing='0' cellpadding='2' class='all' width='100%'>
<tr>
<th>$sitename Network Functions</th>
</tr>

<tr>
<td>
<table cellspacing='0' cellpadding='3' border='0' width='100%'>
<tr>
<td width='50%' nowrap>
");        if($_COOKIE[username] AND $_COOKIE[password])
{
 print("
        <a href='boards/index.php'>Message Boards</a><br>
        <a href='pm/index.php'>Private Mail</a><br>
		<a href='create.php'>Create a Chat</a><br>
				<a href='join.php'>Join a Chat</a><br>
");
}
else
{
print("Need to be logged in.");
} 
print("
</td>
</tr>
</table>
</td>
</tr>
</table>

<br>


<table cellspacing='0' cellpadding='2' class='all' width='100%'>
<tr>
<th>Actions</th>
</tr>

<tr>
<td>
<table cellspacing='0' cellpadding='3' border='0' width='100%'>
<tr>
<td width='50%' nowrap>
");
$sql = mysql_query("SELECT * FROM users WHERE username = '$_COOKIE[username]'");
$row = mysql_fetch_array($sql);

if($_COOKIE[username] AND $_COOKIE[password])
{

print("
        <a href='account.php'>Account</a><br>
        <a href='logout.php'>Logout</a><br>
");
if($row[user_level]==2)
{
print("        <a href='admin/'>Staff Area</a><br>");
}
}
else
{
print("  

        <a href='signup.php'>Signup</a><br>
        <a href='login.php'>Login</a><br>
        <a href='lostpw.php'>Lost Password</a><br>

");
}
print("
</td>
</tr>
</table>
</td>
</tr>
</table>

<br>


<table cellspacing='0' cellpadding='2' class='all' width='100%'>
<tr>
<th>User Status</th>
</tr>

<tr>
<td>
<table cellpadding='2' cellspacing='0' border='0' width='100%'>
<tr>
<td width='50%' nowrap>
");
if($_COOKIE[username] AND $_COOKIE[password])
{
$sql = mysql_query("SELECT * FROM users WHERE username = '$_COOKIE[username]'");
$row = mysql_fetch_array($sql);

$sql2 = mysql_query("SELECT * FROM im WHERE sentto = '$_COOKIE[username]'");
$tot = mysql_num_rows($sql2);

$sql3 = mysql_query("SELECT * FROM im WHERE sentto = '$_COOKIE[username]' AND status = 'unread'");
$un = mysql_num_rows($sql3);
print("
Username: $row[username]<BR>
Chat Nickname: $row[nickname]<BR>
Unread Messages: $un<BR>
Total Messages: $tot<BR>
");

}
else
{
print("
Username --<BR>
Chat Nickname --<BR>
Unread Messages --<BR>
Total Messages --<BR>

");
}
print("
</td>

</tr>
</table>
</td>
</tr>
</table>

<br>
<table cellspacing='0' cellpadding='2' class='all' width='100%'>
<tr>
<th>Popular Rooms</th>
</tr>
");

if($_COOKIE[username] AND $_COOKIE[password])
{

print("
        <tr>
<td>
<table cellspacing='0' cellpadding='3' border='0' width='100%'>
<tr>
<td width='50%' nowrap>
<a href='chatroom.php?rm=TheLobby'>The Lobby</a>
</td>
</tr>
</table>

");
}
print("
</td>
</tr>
</table>
</td>
<td width='20'></td>

<td valign='top'>
<BR><BR>
<!-- Content ==!>
");

?>

Sime388

Anybody got any suggestions!?

TheDefender

Several problems needing to be addressed:

First, just an FYI. When the weekend rolls around, it can take a bit longer to get a reply/help, so be patient.

Second, $COOKIE[username] should look more like this:
$COOKIE['username'] (Note the single quotes around the index's name. Do the same with the password one.

Third, debugging 101... Change your query statements and add a die to them, so they will output the errors. This will help you troubleshoot the problems quicker.
$update = mysql_query("UPDATE users SET lastlogin = '$date' WHERE username = '$_COOKIE[username]'") OR die(mysql_error());

Report back after making these changes, and let's see if that has made any difference in fixing your issues, or if we need to continue on. If the die reports an error, then post back with that.

bodzan

...the mysql result isn't there or is empty (no results) so I would suggest before any mysql_fetch_array() to check if it's empty, like this:

if(mysql_num_rows($sql)!=0){
    //do something
}
else{
    //the result was empty
}

TheDefender

Originally posted by bodzan
...(no results)...

If there were no results, you'd simply have nothing echoed out... Using the mysql_num_rows will help speeed up the page loading when there are no results, but it really won't help troubleshoot the problem in the query itself that's causing the error. No results won't cause this error.

Sime388

Originally posted by TheDefender
Several problems needing to be addressed:

Second, $COOKIE[username] should look more like this:
$COOKIE['username'] (Note the single quotes around the index's name. Do the same with the password one.

Third, debugging 101... Change your query statements and add a die to them, so they will output the errors. This will help you troubleshoot the problems quicker.
$update = mysql_query("UPDATE users SET lastlogin = '$date' WHERE username = '$_COOKIE[username]'") OR die(mysql_error());

Report back after making these changes, and let's see if that has made any difference in fixing your issues, or if we need to continue on. If the die reports an error, then post back with that.

Does that mean that the bit in the update bit needs the sigle quotes on username and password?

Sime388

putting just the single quotes in did nothing, it turned up the exact same errors

to see these errors, please go to chat.simonsforum.com

Sime388

sokay, yall!!
Cheers for all your suggestions, but i was on the only place to think(the bog) when i though - hmmmm, i wonder... does it have an include to config.php, it didnt and i fixed it!! 😃
Im so clever :p

Thanks peeps