UBB.Developers Forums UBB.threads 6 V6 Modifications Finished-[6.3-6.4] My Home Post Statistics 1.2

    // Totals in Days <br />    $strQuery = " <br />        SELECT  left(date_format(FROM_UNIXTIME(B_Posted),'%W'),3) AS DayLiteral, <br />                dayofweek(FROM_UNIXTIME(B_Posted)) AS DayStat, <br />                COUNT(B_Number) <br />        FROM    {$config['tbprefix']}Posts <br />        WHERE   B_PosterId = '$Uid' <br />        GROUP BY DayStat <br />        ORDER BY DayStat ASC"; <br /> <br />    $sth = $dbh->do_query($strQuery); <br /> <br />    $intCounter = 0; <br /> <br />    while (list($Day, $DayNum, $Posts) = $dbh->fetch_array($sth)) { <br />        $aTotalDays[$intCounter]['Day']    = $Day; <br />        $aTotalDays[$intCounter]['Posts']  = $Posts; <br />        $intCounter++; <br />    }