0) AND (location.lid IS NOT NULL) AND (node.type in ('eye_surgeon')) AND (term_node.tid = ". $data['tax_id'] .") AND (location.country = 'US') AND (location.province = '". makeSafe($st_code) ."') AND (location.city = '". makeSafe(text_get('city')) ."')";
/*
*/
/*
$dbquery = "SELECT DISTINCT(node.nid) AS nid,
location.province AS location_province,
location.country AS location_country,
location.city AS location_city
FROM node node
LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
LEFT JOIN location location ON location_instance.lid = location.lid
WHERE (node.vid IN (
SELECT tn.vid FROM term_node tn
LEFT JOIN term_hierarchy th ON th.tid = tn.tid
LEFT JOIN term_hierarchy th1 ON th.parent = th1.tid
LEFT JOIN term_hierarchy th2 ON th1.parent = th2.tid
LEFT JOIN term_hierarchy th3 ON th2.parent = th3.tid
LEFT JOIN term_hierarchy th4 ON th3.parent = th4.tid
LEFT JOIN term_hierarchy th5 ON th4.parent = th5.tid
LEFT JOIN term_hierarchy th6 ON th5.parent = th6.tid
LEFT JOIN term_hierarchy th7 ON th6.parent = th7.tid
)) AND ((location.city) = ('". makeSafe(text_get('city')) ."')) AND (location.province = '". makeSafe($st_code) ."') AND (node.status = 1) AND (node.type in ('$typeofnode'))
GROUP BY nid
ORDER BY location_province ASC, location_city ASC";
*/
$dbquery = "SELECT node.nid AS nid,
location.province AS location_province,
location.country AS location_country,
location.city AS location_city,
location.postal_code AS location_postal_code,
location.street AS location_street,
location.additional AS location_additional,
node.title AS node_title
FROM node node
LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
LEFT JOIN location location ON location_instance.lid = location.lid
WHERE (node.vid IN (
SELECT tn.vid FROM term_node tn
LEFT JOIN term_hierarchy th ON th.tid = tn.tid
LEFT JOIN term_hierarchy th1 ON th.parent = th1.tid
LEFT JOIN term_hierarchy th2 ON th1.parent = th2.tid
LEFT JOIN term_hierarchy th3 ON th2.parent = th3.tid
LEFT JOIN term_hierarchy th4 ON th3.parent = th4.tid
WHERE tn.tid = ". $data['tax_id'] ."
OR th1.tid = ". $data['tax_id'] ."
OR th2.tid = ". $data['tax_id'] ."
OR th3.tid = ". $data['tax_id'] ."
OR th4.tid = ". $data['tax_id'] ."
)) AND ((location.city) = ('". makeSafe(text_get('city')) ."')) AND (location.province = '". makeSafe($st_code) ."') AND (node.status = 1) AND (node.type in ('$typeofnode'))
GROUP BY nid
ORDER BY location_province ASC, location_city ASC";
$dbresult = mysql_query($dbquery);
// if no eye surgeons in this city, redirect to homepage
//while($rrow = mysql_fetch_array($dbresult, MYSQL_ASSOC)) {
// if(empty($rrow[0])) {
//$surgeons_exist = mysql_num_rows($dbquery);
//if(!$surgeons_exist) {
// header("HTTP/1.1 301 Moved Permanently");
// header("Location: ". THISDOMAIN ."/");
// exit();
// }
$cityListQuery = "SELECT location.city AS location_city,COUNT(node.nid) AS num_records FROM node node
LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
LEFT JOIN location location ON location_instance.lid = location.lid INNER JOIN term_node term_node ON node.vid = term_node.vid
WHERE (node.status <> 0) AND (location.lid IS NOT NULL) AND (node.type in ('$typeofnode')) AND (term_node.tid = ". $data['tax_id'] .") AND (location.country = 'US') AND (location.province = '". makeSafe($st_code) ."')
GROUP BY location_city ORDER BY location_city ASC";
$cityListResult = mysql_query($cityListQuery);
$stateListQuery = "SELECT location.province AS location_province, COUNT(node.nid) AS num_records FROM node node
LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid LEFT JOIN location location ON location_instance.lid = location.lid
INNER JOIN term_node term_node ON node.vid = term_node.vid
WHERE (node.status <> 0) AND (location.lid IS NOT NULL) AND (node.type in ('$typeofnode')) AND (term_node.tid = ". $data['tax_id'] .") AND (location.country = 'US')
GROUP BY location_province ORDER BY location_province ASC";
/*
$stateListQuery = "SELECT DISTINCT(node.nid) AS nid,
DISTINCT(location.province) AS location_province,
location.country AS location_country,
location.city AS location_city
FROM node node
LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
LEFT JOIN location location ON location_instance.lid = location.lid
WHERE (node.vid IN (
SELECT tn.vid FROM term_node tn
LEFT JOIN term_hierarchy th ON th.tid = tn.tid
LEFT JOIN term_hierarchy th1 ON th.parent = th1.tid
LEFT JOIN term_hierarchy th2 ON th1.parent = th2.tid
LEFT JOIN term_hierarchy th3 ON th2.parent = th3.tid
LEFT JOIN term_hierarchy th4 ON th3.parent = th4.tid
LEFT JOIN term_hierarchy th5 ON th4.parent = th5.tid
LEFT JOIN term_hierarchy th6 ON th5.parent = th6.tid
LEFT JOIN term_hierarchy th7 ON th6.parent = th7.tid
WHERE tn.tid = ". $data['tax_id'] ."
OR th1.tid = ". $data['tax_id'] ."
OR th2.tid = ". $data['tax_id'] ."
OR th3.tid = ". $data['tax_id'] ."
OR th4.tid = ". $data['tax_id'] ."
OR th5.tid = ". $data['tax_id'] ."
OR th6.tid = ". $data['tax_id'] ."
OR th7.tid = ". $data['tax_id'] ."
)) AND (node.status = 1) AND (node.type in ('$typeofnode'))
GROUP BY nid
ORDER BY location_province ASC";
*/
include(INCLUDEPATH.'flinks/flinks-'. url_w($data['keyword']) .'.php');
// //
$varState = $statecode[text_get('state')];
//include('schools/'. $varState .'.php');
?>
Bourbonnais, Illinois Cataract Surgery - Find a Doctor
