//INCLUDE session_start(); include("includes/connection.php"); $linkid=db_connect(); if ($_REQUEST["ID"]) { $_REQUEST["ID"] = mysql_real_escape_string($_REQUEST["ID"]); } ?>
$sql = "select * from category where id='".$_REQUEST["ID"]."' and visible=1"; $result = mysql_query($sql); if (mysql_numrows($result) == 0){ print "
$sql = "SELECT * FROM category WHERE id = '" . $_REQUEST["ID"]. "' AND visible=1";
//print $sql;
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0) {
$query_data = mysql_fetch_array($result);
$this_parent = $query_data["parent"];
if ($query_data["parent"] != 0){
$trail = "» ".$query_data["category"]."".$trail;
}else{
$trail = "» ".$query_data["category"]."".$trail;
}
while ($this_parent != 0){
$sql = "SELECT * FROM category WHERE id = '".$this_parent. "' AND visible=1";
//print $sql;
$result = mysql_query($sql);
$query_data = mysql_fetch_array($result);
if ($query_data["parent"] != 0){
$trail = " » ".$query_data["category"]." ".$trail;
}else{
$trail = "".$query_data["category"]." ".$trail;
}
$this_parent = $query_data["parent"];
}
}
print "Home " . $trail;
?>
echo $catname ?>if($_REQUEST['ID']!="") { $id=$_REQUEST['ID']; $select_sql = "SELECT * FROM category WHERE visible=1 AND parent='".$id."'"; $result = mysql_query($select_sql); $numcats=mysql_num_rows($result); if($numcats>0) { print "Sub categories:"; while ($query_data = mysql_fetch_array($result)) { print "• ".$query_data["category"]." \n"; } } } ?> if($_REQUEST['ID']!=""){ $id=$_REQUEST['ID']; $sql_root="select * from category where id='".$id."' and visible=1"; $res_root=mysql_query($sql_root); $no_root=mysql_num_rows($res_root); if($no>0){ $rs=mysql_fetch_row($res_root); if ($rs[2]!=""){ $str1= fnRootFinder($rs[2]); //echo $str1; } echo "". $rs[1]." "; } } ?> if($_REQUEST['ID']!=""){ $sql="SELECT * from premium_listing where visible=1 and category='".$_REQUEST['ID']."' order by id asc"; }else{ $sql="SELECT * from premium_listing where visible=1 order by id asc"; } $res=mysql_query($sql); $no=mysql_num_rows($res); if($no>0){ echo " Recommended Sites"; //$rs=mysql_fetch_object($res); while($rs=mysql_fetch_object($res)){ $linktarg = $rs->link_target; if (substr($rs->link_target, 0,7) != "http://"){ $linktarg = "http://" . $rs->link_target; } ?>
if($rs->image!=""){ ?>
}
}else{
$is_record="P";
}
?>
if($_REQUEST['ID']!=""){
$sql="SELECT * from basic_listing where visible=1 and category='".$_REQUEST['ID']."' order by id asc";
}else{
$sql="SELECT * from basic_listing where visible=1 order by id asc";
}
$res=mysql_query($sql);
$no=mysql_num_rows($res);
if($no>0){
echo "Rating : for($iC=0;$iC<$rs->rating;$iC++){ ?> } ?> Visit this site echo "Category: ".getCategory($rs->category); ?> Other sites in this category"; //$rs=mysql_fetch_object($res); while($rs=mysql_fetch_object($res)){ $linktarg = $rs->link_target; if (substr($rs->link_target, 0,7) != "http://"){ $linktarg = "http://" . $rs->link_target; } ?> No Websites under this category"; } ?> function getCategory($id) { $sql_inner="select * from category where id='".$id."'"; $res_inner=mysql_query($sql_inner); $no=mysql_num_rows($res_inner); if($no>0){ $rs=mysql_fetch_object($res_inner); $category=$rs->category; } return $category; } function fnRootFinder($id) { if($id!=""){ $sql_root="select * from category where id='".$id."' and visible=1"; $res_root=mysql_query($sql_root); $no_root=mysql_num_rows($res_root); if($no_root>0){ $rs=mysql_fetch_row($res_root); $str.= "".$rs[1]." » "; ?> if($rs[2]!=""){ fnRootFinder($rs[2]); } } } echo $str; //return $str; } ?> |
||||
© copyright 2006 - 2024 Go Dating Ltd. All rights reserved. Website design by Reverse Delta | ||||
$_SESSION['numcount'];
$_SESSION['numcount'] = 1;
function displayfooterlinks($cat_id, $first, $link_text)
{
$select_sql = "SELECT * FROM category WHERE visible=1 AND parent='".$cat_id."'";
$result = mysql_query($select_sql);
//if (($first == 1) && ($cat_id != 1)){
//print " "; //} if (($_SESSION['numcount'] % 3) == 0){ print " "; } $_SESSION['numcount'] ++; while ($query_data = mysql_fetch_array($result)) { // display sub-categories within this category. if ($first == 0){ $link_text = $query_data["category"]; }else{ $link_text = $link_text . " >> " . $query_data["category"]; } $link_text = "Speed Dating " . $query_data["category"]; if ($first == 0) { print "".$link_text." | \n"; } else if ($first == 1) { print "".$link_text." | \n"; }else if ($first == 2){ print "".$link_text." | \n"; } displayfooterlinks($query_data["id"], $first+1, $link_text); } } displayfooterlinks(1, 0, ""); ?>
We at Speed Dating London spend time reviewing online dating websites aimed at both professionals and non-professionals, internet dating sites, asian dating sites, singles events organisers and any other relevant organisations. Internet or Online Dating is the new way to meet people in London and other large cities such as Leeds, Birminham, Manchester, Liverpool and Sheffield. Almost everyone now has access to the internet, so the web provides the perfect opportunity for professional single men and single women to meet from their our own homes and offices. Anyone who has been to an internet or real life personal dating agency, especially if they are professional, they will appreciate the opportunities to me matched with like minded single people.
|