Returning 0 with mysql_num_rows

Jeffreyc

Hi..
I have this strange problem with mySQL and PHP.

I have this page which mysql_num_rows return 0 and it shouldn't.
When I refresh it a couple of times(once, twice, or X amount of times 😕 ) then it returns the correct number which is 1.

The SQL statement is as follows:

$sql = "SELECT * FROM $CurrentlyLoginedInfoDB WHERE (SessionID like '$SessionIDSent') AND (IPAddress like '$REMOTE_ADDR') ";
$Logon = mysql_query($sql, $link);

Where SessionIDSent comes from cookies and IPAddress is built-in, I even did a <?php echo $sql ?> to make sure its always the correct statement everytime. But somehow it could produce different outputs at different instances. I'm the only one using it, so there couldn't be any monsters eating up the mySQL data.

Anyone have something happen like this before? I've been stuck with this problem for a week already. 🙁

dancahill

It would be useful to see some more of your code to tell but maybe the $SessionIDSent variable is not being assigned properly 1st time round? This may mean that it will only be available to the SQL statement after you refresh the page?

As I say it's difficult to tell without seeing some more of the code like where and how the sessionID is being called.

Jeffreyc

<?php

$SessionIDSent = $HTTP_COOKIE_VARS["SessionIDSent"];
$type = $HTTP_COOKIE_VARS["type"];
$username = $HTTP_COOKIE_VARS["username"];
$Name = $HTTP_COOKIE_VARS["Name"];
if($SessionIDSent == NULL)
die("Not Logined, Please Click here to Login1");
$sql = "SELECT FROM $CurrentlyLoginedInfoDB WHERE (SessionID like '$SessionIDSent') AND (IPAddress like '$REMOTE_ADDR') ";
$Logon = mysql_query($sql, $link);
echo $sql;
$sql2 = "SELECT FROM $LoginID_DB WHERE (SessionID like '$SessionIDSent') AND (IPAddress like '$REMOTE_ADDR') ";
$Logon2 = mysql_query($sql2, $link);
if (!$Logon)
{
die("<BR><B>query failed: ".mysql_error());
}
if(mysql_num_rows($Logon) == 1)
{
$record = mysql_fetch_array($Logon);
$username = $record[LoginID];

$sql2 = "SELECT * FROM $LoginID_DB  WHERE LoginID like '$username'";
$Logon2 = mysql_query($sql2, $link);
$record2 = mysql_fetch_array($Logon2);

$usertype = $record2[LoginType];
//Successful Login
setcookie("SessionIDSent", $SessionIDSent,time()+3600);
setcookie("type", $type,time()+3600);
setcookie("username", $username,time()+3600);
setcookie("Name",$Name,time()+3600);

}
else if(mysql_num_rows($Logon) == 0)
{
//Usually gets stopped
die("Not Logined, Please Click here to Login");
//Not Logined

}

The point is that, the mysql_num_rows($Logon) should return 1. But only sometimes does it return 0. Sometimes it is the first time it returns correctly, or maybe you have to refresh a couple of times. Maybe is there something wrong with mySQL prehaps?