I am learning php and I am trying to get this php script to return a result when called by a browser. Can someone look at it and give me a hand?
PHP Code:
$start_date = "2004-08-01 00:00:00";
$end_date = "2004-08-23 00:00:00";
$result = $DB_site->query("SELECT COUNT(post.postid) AS count, user.username
FROM post
LEFT JOIN user ON (user.userid = post.userid)
AND (UNIX_TIMESTAMP('$start_date')) <= post.dateline
AND post.dateline <= (UNIX_TIMESTAMP('end_date'))
GROUP BY user.userid ORDER BY count DESC, username");