<?php
/**
 * @version 2.2
 * @since 2.0 2008-08-06
 * @package kwalbum
 */

$G = &$_GET;
?>
<big><b><?php echo $URLP->GetTitle(); ?></b></big>
<div class='kwalbumBox' style='min-width:300px;width:45%;'>
<h2>Most Popular</h2>
<table>
<tr><th><a href='<?php echo PAGE_URL; ?>p=Locations'>Locations</a></th><th>Total Views</th></tr>
<?php
	if (0 < $popLocationResults->num_rows)
		while($row = $popLocationResults->fetch_assoc())
		{
			echo "<tr><td><a href='".PAGE_URL."loc=$row[Location]'>$row[Location]</a></td><td>$row[Total]</td></tr>\n";
		}
?>
</table>
<br/>
<table>
<tr><th><a href='<?php echo PAGE_URL; ?>p=Tags'>Tags</a></th><th>Total Views</th></tr>
<?php
	if (0 < $popTagResults->num_rows)
		while($row = $popTagResults->fetch_assoc())
		{
			echo "<tr><td><a href='".PAGE_URL."tags=$row[Tag]'>$row[Tag]</a></td><td>$row[Total]</td></tr>\n";
		}
?>
</table>
</div>

<div class='kwalbumBox' style='min-width:300px;width:45%;
'>
<h2>Newest Additions</h2>
<table>
<tr><th><a href='<?php echo PAGE_URL; ?>p=Locations'>Locations</a></th><th>Date of Addition</th></tr>
<?php
	if (0 < $newLocationResults->num_rows)
		while($row = $newLocationResults->fetch_assoc())
		{
			echo "<tr><td><a href='".PAGE_URL."loc=$row[Location]&amp;months=36'>$row[Location]</a></td><td>".date('F d, Y', strtotime($row['NewestDate']))."</td></tr>\n";
		}
?>
</table>
<br/>
<table>
<tr><th><a href='<?php echo PAGE_URL; ?>p=Tags'>Tags</a></th><th>Date of Addition</th></tr>
<?php
	if (0 < $newTagResults->num_rows)
		while($row = $newTagResults->fetch_assoc())
		{
			echo "<tr><td><a href='".PAGE_URL."tags=$row[Tag]&amp;months=36'>$row[Tag]</a></td><td>".date('F d, Y', strtotime($row['NewestDate']))."</td></tr>\n";
		}
?>
</table>
</div>