0){
$start = ($_REQUEST["page"]*40);
}else{
$start = 0;
}
if($_REQUEST["switch"] == "new"){
$order = "ORDER BY forum.ID desc";
}else{
$order = "ORDER BY forum.lastvoteint desc";
}
if($dblon <> 0){
$distance = 100;
$stmt = $pdodb->prepare("SELECT girls.ID as ID,forum.titleis,forum.descis,forum.lastcomment,forum.seox,forum.country,forum.lastcommentpic,forum.classified, girls.mainpic,forum.timeposted,girls.username,forum.question,forum.nreplies,forum.forum,forum.forumseo,forum.votepoints,forum.views,forum.nreplies,forum.votes,forum.mainpic as newspic,urlis, SQRT(
POW(69.1 * (forum.dblat - :dblat), 2) +
POW(69.1 * (:dblon - forum.dblon) * COS(forum.dblat / 57.3), 2)) AS distance FROM forum LEFT JOIN girls ON girls.ID=forum.mid WHERE forum=: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,forum.ID as fid, forum.titleis,forum.lastcomment,forum.descis,forum.seox,forum.country, girls.mainpic,forum.timeposted,girls.username,forum.question,forum.classified,forum.dating,forum.nreplies,forum.lastcommentpic,forum.forum,forum.forumseo,forum.votepoints,forum.views,forum.nreplies,forum.votes,forum.mainpic as newspic,urlis FROM forum LEFT JOIN girls ON girls.ID=forum.mid WHERE forum=: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';
}
?>