MySQL Array

[jamesm87]

$sql = "select * from users where expire>'".time()."'";
$result= mysql_query($sql);
if(!$result)
{
	error('SQL',mysql_error());
}
if(mysql_num_rows($result)>0){

echo mysql_num_rows($result)."<br/><br/>";

while($row = mysql_fetch_array($result)){


}

}

Why does the output show..

56

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/hr/public_html/remixclub_crontool.php on line 51

Because there is obviously 56 rows? :S

Thanks!

[atokatim]

try using mysql_fetch_object($result) instead of mysql_fetch_array($result)

$sql = "select * from users where expire > '".time()."'";
$result= mysql_query($sql);
if(!$result)
{
    error('SQL',mysql_error());
}
if(mysql_num_rows($result)>0){

echo mysql_num_rows($result)."<br/><br/>";

while($row = mysql_fetch_object($result)){

echo $row->expire."<br>";

}

} 

[jamesm87]

56

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/hr/public_html/remixclub_crontool.php on line 51

Its extremely wierd this error. :S

[atokatim]

Try this

 
$thetime = time();
$sql = mysql_query("SELECT * FROM users WHERE expire > '$thetime'");

if(!$sql)
{
    error('SQL',mysql_error());
}
if(mysql_num_rows($sql)>0){

echo mysql_num_rows($sql)."<br/><br/>";

while($row = mysql_fetch_object($sql)){

echo $row->expire."<br>";

}

}