More...";
?>
";
echo "".$row["name"]."";
echo "
";
}
?>
|
Active Threads
";
echo "".$row["title"]."";
echo " (".$row["numcomments"].")"."More... ";
?>
|
Last Three Days Of Discussthing
$gtime
- SELECT something FROM tbl_name -> WHERE DATE_SUB(CURDATE(),INTERVAL $c_lastxdays DAY) <= $curdate;
*/
//$cday = date("j");
//$gday = $cday - $c_lastxdays;
$SQLSTR = "SELECT threadid, userid, DATE_FORMAT(posttime, '%W %c/%e/%y') AS pdate, DATE_FORMAT(posttime, '%l:%i %p') AS ptime, content FROM posts
WHERE posttime > DATE_SUB('$curdate',INTERVAL $c_lastxdays DAY)
AND posttime <= '$curdate'
ORDER BY posttime DESC";
//die($SQLSTR);
$result = mysql_query($SQLSTR, $db);
while($row = mysql_fetch_array($result))
{
drawPostPreview($row, $db);
}
?>
ok?