0){
$start = ($_REQUEST["page"]*40);
}else{
$start = 0;
}
if($_REQUEST["switch"] == "new"){
$order = "ORDER BY page.ID desc";
}else{
$order = "ORDER BY page.lastvoteint desc";
}
if($dblon <> 0){
$distance = 100;
$stmt = $pdodb->prepare("SELECT girls.ID as ID,page.titleis,page.descis,page.lastcomment,page.seox,page.country,page.lastcommentpic,page.classified, girls.mainpic,page.timeposted,girls.username,page.question,page.nreplies,page.forum,page.forumseo,page.votepoints,page.views,page.nreplies,page.votes,page.mainpic as newspic,urlis, SQRT(
POW(69.1 * (page.dblat - :dblat), 2) +
POW(69.1 * (:dblon - page.dblon) * COS(page.dblat / 57.3), 2)) AS distance FROM page LEFT JOIN girls ON girls.ID=page.mid WHERE page=:forumid HAVING distance < :distance ".$order." LIMIT :start,40");
$stmt->bindParam(':start',$start,PDO::PARAM_INT);
$stmt->bindParam(':distance',$distance);
$stmt->bindParam(':dblat',$dblat);
$stmt->bindParam(':dblon',$dblon);
$stmt->bindParam(':forumid',$forumid,PDO::PARAM_INT);
$stmt->execute();
}else{
$stmt = $pdodb->prepare("SELECT girls.ID as ID,page.ID as fid, page.titleis,page.lastcomment,page.descis,page.seox,page.country, girls.mainpic,page.timeposted,girls.username,page.question,page.classified,page.dating,page.nreplies,page.lastcommentpic,page.forum,page.forumseo,page.votepoints,page.views,page.nreplies,page.votes,page.mainpic as newspic,urlis FROM page LEFT JOIN girls ON girls.ID=page.mid WHERE page=:forumid ".$order." LIMIT :start,40");
$stmt->bindParam(':start',$start,PDO::PARAM_INT);
$stmt->bindParam(':forumid',$forumid,PDO::PARAM_INT);
$stmt->execute();
}
$i=0;
while($i3=$stmt->fetch()) {
include('newsitem.php');
}
if($stmt->rowCount() == 0){
echo 'no more entries';
}
?>