2 queeries of the same to one.

[SmEdD]

How can I make this into one querie. I belive you can just not smart enought. Still a n00b.

PHP Code:

$getpoststoday=$DB_site->query_first("SELECT count(*) AS count FROM post WHERE dateline>='$vbs_today'");
$poststoday=number_format($getpoststoday[count]);
$getthreadstoday=$DB_site->query_first("SELECT count(*) AS count FROM thread WHERE dateline>='$vbs_today'");
$threadstoday=number_format($getthreadstoday[count]); 


[SmEdD]

NVM I'm a idiot you can't because there diffrewnt tables.

[filburt1]

Why not? Look up JOINs and other tricks.

[Xenon]

on table is enough for that:

PHP Code:

$getpoststoday = $DB_site->query_first("SELECT count(postid) AS posts, COUNT(DISTINCT(threadid)) AS threads FROM post WHERE dateline>='$vbs_today'");
$poststoday = number_format($getpoststoday['posts']);
$threadstoday = number_format($getthreadstoday['threads']); 


[Boofo]

How would you add today's thread views in there?

[Xenon]

Bob, it's impossible, because threadviews are not saved with datelines, so you can just get the ammount of views those threads have in total

[Boofo]

Shows you what I know about queries, huh?