<br />
<br />
<?php
}
$paging;
$query = new Query("advertisement");
if (isset($_GET['category'])) {
$query->whereQuery("*", "category", $_GET['category'], "date", "DESC", 1000);
$paging = new Paging($query, 20);
$paging->where("*", "category", $_GET['category'], "date", "DESC");
} else {
$query->makeQuery("*", "date", "DESC", 100);
$paging = new Paging($query, 20);
$paging->makePagingQuery();
}
while ($row = mysql_fetch_assoc($paging->getResult())) {
$getCategory = new Query("advertisement_categories");
$getCategory->whereQuery("*", "rowid", $row['category'], "rowid", "ASC", 1000);
?>
<table border="0" cellpadding="0" cellspacing="0" class="demoTable">
<tr>
<td class="tdPadding" colspan="2"><span class="boldGreyLighter"><?php
echo $row['title'];
?>
</span><span class="smallGrey"> -
<?php
echo $getCategory->getResultRow("category");
?>
</span><br /><br />
