Saskatchewan Vets

[Canadian Animal Hospitals and Clinics]

Below we list every town in Saskatchewan for which we have information for medical care professionals. Just scroll down to your town to get a list of all the local Animal Care Professionals and Hospitals in your area.

[INSERT_PHP]
include(“/home/bruning/public_html/includes/ca_vets_login.php”);

$query = “select DISTINCT city from vets_ca where (prov=’SK’) order by city asc”;
$query2 = mysqli_query($con,$query) or die(mysqli_error());
while ($query3 = mysqli_fetch_array($query2)) {
$tempcity = $query3[‘city’];
if ($tempcity) {
echo “

“;
echo “

Animal Care in $tempcity $tempcity

“;
$vetquery = “select name,phone,address from vets_ca where (prov=’SK’) and (city='”;
$vetquery .= $tempcity . “‘) order by name asc”;
$vetquery2 = mysqli_query($con,$vetquery) or die(mysqli_error());
$count = 0;
echo “

“;
while ($vetquery3 = mysqli_fetch_array($vetquery2)) {
if ($count == “0”) { echo “

“; }
$name = $vetquery3[‘name’]; $name = str_replace(‘”‘,””,$name);
$phone = $vetquery3[‘phone’];
$address = $vetquery3[‘address’]; $address = str_replace(‘”‘,””,$address);
echo “

“;
$count++;
if ($count == “2”) { echo “

“; $count = 0; }
}
echo “

$name
$address
$phone

“;
echo “

“;
}
}
[/INSERT_PHP]