where do i put the if statement?

[joey3002]

I need some help with this code..
$tx_adminPosts = array();
$query = mysql_unbuffered_query('SELECT thread.title WHERE thread.forumid = 24 AND thread.lastpost > UNIX_TIMESTAMP() - 1814400');
while ($tx_adminPosts[] = mysql_fetch_row($query));

what that code does it pulls data that is less than 21 days old. What i want to add, is something so that if there is no data, put a simple text line like "No Data Newer than 21 days"

thanks in advance for any help

[Piranha]

Normally I would say that you could do something like this:

if (mysql_num_rows == 0)
{
    // Do what you want to be done
}

But since you use mysql_unbuffered_query this is not possible. I think I would first do a query to find out how many rows will be returned. If it is 0 then do nothing else, if it is not 0 then continue with the rest. Of course there are the possibility to check the size of $tx_admin_Posts as well. Use [man]count[/man] for this.

[joey3002]

Resolved

[Piranha]

Please mark the thread as resolved then.