You are about to submit a dating tip for = strtolower($peopledisp) ?> in = $locdesc ?>
If this is not the most appropriate category for your tip, please go back and select a different category.
fullySanitize($_GET['key']); if (strlen($key) == 0) $key = "singles-US"; $depth = 1; // 1 for country, 2 for state, 3 for city $keys = explode("-", $key); $cat = $keys[0]; // this is cat_path $country = $keys[1]; // this is loc_path of country $state = ""; // this is loc_path of state $city = ""; // this is loc_path of city $catdisp = ""; // this is display value for category, ex. "Christian Singles" $peopledisp = ""; // this is display value for people of above category, which may differ from above $locdesc = ""; // description of the top location, ex. "Reno, NV" $toplocpath = $country; if (count($keys) > 2) { $state = $keys[2]; $toplocpath = $state; $depth = 2; } if (count($keys) > 3) { $city = $keys[3] . '_' . strtolower($state); $toplocpath = $city; $depth = 3; } $trans = TransManager::getInstance(); $trans->beginTrans(); $pdo = $trans->getPDO(); $stmt = $pdo->prepare('SELECT display, people_disp FROM category WHERE cat_path = ?'); $stmt->bindParam(1, $cat); $stmt->execute(); $myrow = $stmt->fetch(PDO::FETCH_NUM); $catdisp = $myrow[0]; $peopledisp = $myrow[1]; $stmt = $pdo->prepare('SELECT name FROM location WHERE loc_path = ?'); $stmt->bindParam(1, $toplocpath); $stmt->execute(); $myrow = $stmt->fetch(PDO::FETCH_NUM); $locdesc = $myrow[0]; ?>
If this is not the most appropriate category for your tip, please go back and select a different category.