Here is a link:
My Test Page
Here is the php script:
PHP Code:
<?PHP
$templatesused = "postdate";
require("./global.php");
$start_date = "2004-07-01 00:00:00";
$end_date = "2004-07-31 00:00:00";
$stmt = $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");
echo "<table border=1 cellspacing=0>";
$result = ($stmt) or die (mysql_error()."<br />Couldn't execute query: $stmt");
while($row = mysql_fetch_row($result))
{
echo "<tr>";
for($i = 0; $i < mysql_num_fields($result); $i++)
{
echo "<td>" . $row[$i] . "</td>";
}
echo "</tr>";
}
echo "</table>";
eval('print_output("' . fetch_template('TEST') . '");');
eval('$navbar = "' . fetch_template('navbar') . '";');
?>
and the template:
HTML Code:
$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<title>$vboptions[bbtitle]</title>
$headinclude
</head>
<body>
$header
$navbar
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat">Title</td>
</tr>
<tr>
<td class="alt1">Text</td>
</tr>
</table>
$footer
</body>
</html>
Can I just assign a variable in Includes_start and call it in the template?
08-30-2004, 01:43 AM
Hybrid Mode
