query("SELECT * FROM locations WHERE location_id='$get->location_id'"); $res->fetchInto($row); $res->free(); if(file_exists("images/locations/thumbs/$row->location_id.jpg")){ $img = "location_id.jpg\" alt=\"$row->locationName\" style=\"float:right\">"; }else{ $img = ""; } $row->locationDesc = nl2br($row->locationDesc); if(($row->url!="")&&($row->url!="http://")){ $website.=<<Website: $row->url
eof; }else{ $website = ""; } $row->locationDesc = nl2br($row->locationDesc); print<<$row->locationName

Back

$img

Address:
$row->address1 $row->address2 :: $row->city, $row->state $row->zip
Phone: $row->phone
Fax: $row->fax
$website

Description

$row->locationDesc

eof; break; //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //view all //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// case"viewall"; print<<National School of Dental Assisting Locations eof; $res = $db->query("SELECT distinct(state) FROM locations ORDER BY state ASC"); while($res->fetchInto($r)){ print<< eof; $printed=0; $result = $db->query("SELECT * FROM locations WHERE state='$r->state' ORDER BY locationName ASC"); while($result->FetchInto($row)){ if($printed%2!=0){$class="list1";}else{$class="list2";} if(file_exists("images/locations/thumbs/$row->location_id.jpg")){ $img = "location_id.jpg\" alt=\"$row->locationName\" style=\"float:right;padding:0px 0px 10px 10px; \">"; }else{ $img = ""; } if(strlen($row->locationDesc)>350){ $row->locationDesc = substr($row->locationDesc,0,350)."..."; } if(($row->url!="")&&($row->url!="http://")){ $website=""; $website.=<<Website: $row->url eof; }else{ $website = ""; } $row->locationDesc = nl2br($row->locationDesc); print<< eof; $printed++; } print""; } print"

The National School of Dental Assisting has $locationCount locations in $stateCount different states. To view locations near you, choose the state closest to you in the menu below and click "View Locations" to continue.

Choose Your State


$r->state
$img

$row->locationName

Address:
$row->address1 $row->address2 :: $row->city, $row->state $row->zip
Phone: $row->phone
Fax: $row->fax
$website
More Information



"; break; //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //view all //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// case"viewstate"; print<<National School of Dental Assisting Locations eof; $printed=0; $result = $db->query("SELECT * FROM locations WHERE state='$r->state' ORDER BY locationName ASC"); while($result->FetchInto($row)){ if($printed%2!=0){$class="list1";}else{$class="list2";} if(file_exists("images/locations/thumbs/$row->location_id.jpg")){ $img = "location_id.jpg\" alt=\"$row->locationName\" style=\"float:right;padding:0px 0px 10px 10px; \">"; }else{ $img = ""; } if(strlen($row->locationDesc)>350){ $row->locationDesc = substr($row->locationDesc,0,350)."..."; } if(($row->url!="")&&($row->url!="http://")){ $website=""; $website.=<<Website: $row->url eof; }else{ $website = ""; } $row->locationDesc = nl2br($row->locationDesc); print<< eof; $printed++; } print""; } print"

The National School of Dental Assisting has $locationCount locations in $stateCount different states. To view locations near you, choose the state closest to you in the menu below and click "View Locations" to continue.

Choose Your State
eof; $res = $db->query("SELECT distinct(state) FROM locations WHERE state='$get->state' ORDER BY state ASC"); while($res->fetchInto($r)){ print<<
$r->state
$img

$row->locationName

Address:
$row->address1 $row->address2 :: $row->city, $row->state $row->zip
Phone: $row->phone
Fax: $row->fax
$website
More Information



"; break; //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //default //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// default: $locationCount = $db->getOne("SELECT COUNT(*) FROM locations"); $stateCount = $db->getOne("SELECT COUNT(DISTINCT(state)) FROM locations"); print<<National School of Dental Assisting Locations

The National School of Dental Assisting has $locationCount locations in $stateCount different states. To view locations near you, choose the state closest to you in the menu below and click "View Locations" to continue.

Choose Your State

View all locations

eof; break; } include("inc/foot.php"); ?>