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'); ?> Texarkana, Texas LASIK Eye Surgery - Find a Doctor

Texarkana LASIK Eye Surgery

Find LASIK in Texarkana Today

LASIK Eye Surgery in Texarkana