The Arcive of vBulletin Modifications Site.

2 queries tied together? · **Released**: 07-09-2002

i have this code:

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?

Neo · #2 07-09-2002, 07:02 PM

I dont thing so. Unless it was from the same table.

g-force2k2 · #3 07-10-2002, 03:54 AM

yeah from my small knowledge of mysql i have to agree with neo... i doubt its possible ;\

g-force2k2