// get the state code coming in include ("../db/db.php"); $connection=mysql_connect($dbHost,$dbUser,$dbPass); $db = mysql_select_db($dbDatabase, $connection); $lstate = $_GET['state']; if (empty($lstate)) header("location:http://www.dogtrainersearch.com/dogtraining"); // replace lstate $hstate = $lstate; $lstate = str_replace("-"," ",$lstate); $sql = "select abbr from pmd_states where state = '".mysql_escape_string($lstate)."'"; $result = mysql_query($sql); $row = mysql_fetch_assoc($result); $sql1 = "select * from pmd_locations loc left join pmd_listings lis on (loc.id = lis.loc_id) where title = '".mysql_escape_string($lstate)."' order by rand() limit 0,5"; $result1 = mysql_query($sql1); $sql = "select friendly_url,id from pmd_locations where friendly_url like '".str_replace(" ","%",$lstate)."'"; $result = mysql_query($sql); while ($row2 = mysql_fetch_row($result)) { $location_id = $row2[1]; } ?>
//conntect to the db
$sql = "select friendly_url,id from pmd_locations where friendly_url like '".str_replace(" ","%",$lstate)."'";
$result = mysql_query($sql);
while ($row2 = mysql_fetch_row($result)) {
$location_id = $row2[1];
}
?>
Dog Training in print $lstate; ?> | Dog TrainersIn order to find a quality dog training professional in , you should do your research. Currently does not have any state regulations on becoming a dog trainer. Its important to find a professional who has not only experience, but someone who has a national certification. The CCPDT is a certification for Pet Dog Trainers. If your goal is to have a well behaved family pet, this is a great dog training certification to look for. Our dog trainers directory has several professionals listed.
include("../dts/midgoogle.php"); ?>
See more dog trainers in our directory by clicking here Dog Trainers inwhile ($row1 = mysql_fetch_assoc($result1)) { if ($row1['business']) { print "".strip_tags($row1['business_short'])."";
print " See more dog trainers in our directory by clicking here Types of dog training offered inYou can find puppy training, dog training for rescue dogs, behavioral problems and general tips and advice on obedience. To see all our registered CPDT's and positive based dog trainers, visit our national directory. | |||||