TECK
07-09-2002, 01:56 PM
i have this code:$getthreads=$DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE lastpost>$bbuserinfo[lastvisit]");
$lastthreads=number_format($getthreads['threads']);
$getposts=$DB_site->query_first("SELECT count(*) AS posts FROM post WHERE dateline>$bbuserinfo[lastvisit]");
$lastposts=number_format($getposts['posts']);is there a way to perform one single query instead of 2?
$lastthreads=number_format($getthreads['threads']);
$getposts=$DB_site->query_first("SELECT count(*) AS posts FROM post WHERE dateline>$bbuserinfo[lastvisit]");
$lastposts=number_format($getposts['posts']);is there a way to perform one single query instead of 2?