Crouch End, Gospel Oak, Archway
Crouch End | New Orleans Walk | Gospel Oak | Archway |
if (!is_numeric($page)) {
$page = 1;
}
if (!is_numeric($perpage)) {
$perpage = 20;
}
$offset = ($page - 1) * $perpage;
$sql = "SELECT count(*) as car_count FROM fokm_best_copy WHERE deleted = '0'";
// $query_result = mysql_query($sql);
$stm = $con->prepare($sql);
$query_result = $stm->execute();
$res12 = $stm->fetchAll();
// $count = mysql_result($query_result, 0, 'car_count');
$count = $res12[0]['car_count'];
//$count = 31; // TODO Fix this - should perform "";
$x = 1;
for ($i = 1; $i <= $count; $i += $perpage) {
?>
$x++;
}
?>
prepare($query);
$query_result = $stm->execute();
$count = $stm->rowCount();
$res12 = $stm->fetchAll();
$query = "SELECT * FROM fokm_best_copy WHERE town = 'highgate'";
//
// $query_result = mysql_query($query);
$stm = $con->prepare($query);
$query_result = $stm->execute();
$count = $stm->rowCount();
$res12 = $stm->fetchAll();
if ($count > 0) {
for ($i = 0; $i < $count; $i++) {
//if (in_array(mysql_result($query_result, $i, 'make'), $makePermissions) && in_array(mysql_result($query_result, $i, 'area'), $areaPermissions)) {
echo "
- " . (is_numeric($res12[$i]['make']) ? getMake($res12[$i]['make']) : $res12[$i]['make']) . " " . $res12[$i]['model'] . " " . $res12[$i]['year'] . " " . (is_numeric($res12[$i]['area']) ? getArea($res12[$i]['area']) : $res12[$i]['area']) . " " . $res12[$i]['town'] . " " . date("h.ia", strtotime($res12[$i]['datetime'])) . "