check if table is empty

[Garrett_44]

hello

can anyone tell me how can i check if a table is empty, is there something which can test if it is void??

$query = "SELECT * FROM sessions WHERE (created < time()-1200)";
$result = mysql_query($query);

for the moment i am using this but if i try to do anything with $result it causes an error.

Garrett

[tress]

$query = "SELECT * FROM sessions WHERE (created < time()-1200)";
$result = mysql_query($query); 
if(mysql_num_rows($result)>0)
{
echo 'do something with results';
}
else
{
echo 'empty result set';
} 

or you could use mysql_fetch_object/mysql_fetch_array and use is_object/is_array on the result,
for example

$query = "SELECT * FROM sessions WHERE (created < time()-1200)";
$result = mysql_query($query); 
$object=mysql_fetch_object($result);
if(is_object($object))
{
echo 'do something with results';
}
else
{
echo 'empty set';
} 

[Garrett_44]

same thing as i have already tried really and your two suggestions create the same errors that mine have been creating. ie

"Supplied argument is not a valid MySQL result resource in"

the two following lines are what are creating the problems because its trying to do something with $result which is nothing!!

if(mysql_num_rows($result)>0);
$object=mysql_fetch_object($result);

garrett

[tress]

well then your query is invalid, looking at it i suspect you want

$query = "SELECT * FROM sessions WHERE (created < ".time()-1200.")";