0 ORDER BY practice_id DESC "; $rows = mysqli_query($conn, $sqlr) or die("Error Selecting Profile: ".mysqli_error($conn)); $num_rows = mysqli_num_rows($rows); ?>

Dental Practices Located in Issaquah, WA


  • , ,
DentalPlans.com
0 AND profile_status > 0) OR '; } $condition = rtrim($condition,' OR '); //list($mycity, $mystate) = explode('-', $mylocation); } // DB QUERY //$profile_id = $_REQUEST['pid']; if(isset($condition)) { $qid = "SELECT * FROM azdp_profiles LEFT JOIN azdp_practices ON azdp_profiles.profile_practice_id = azdp_practices.practice_id LEFT JOIN azdp_specialties ON azdp_profiles.profile_specialty1 = azdp_specialties.specialty_id WHERE $condition ORDER BY rand() limit 1"; } else { $qid = "SELECT * FROM azdp_profiles LEFT JOIN azdp_practices ON azdp_profiles.profile_practice_id = azdp_practices.practice_id LEFT JOIN azdp_specialties ON azdp_profiles.profile_specialty1 = azdp_specialties.specialty_id WHERE profile_featured > 0 AND profile_status > 0 ORDER BY rand() limit 1"; } $rows = mysqli_query($conn, $qid) or die("error: not able to retrieve id".mysqli_error($conn)); $num_rows = mysqli_num_rows($rows); if ($num_rows > 0 ) { while($row = mysqli_fetch_array($rows)) { $profile_id = $row['profile_id']; $practice_id = $row['practice_id']; $practice_name = $row['practice_name']; $fsalut = $row['profile_salut']; $name_first = trim($row['profile_first']); $name_mi = trim($row['profile_mi']); $name_last = trim($row['profile_last']); $suffix = $row['profile_suffix']; $specialty1 = $row['specialty_name']; $city = $row['practice_city']; $state = $row['practice_state']; $designations = $row['profile_designations']; $photo = $row['profile_photo']; } // END DB QUERRY $nameURL = $name_first.'_'.$name_last; $name_full = $name_first; if (isset($name_mi) && $name_mi != '') { $name_full .= ' '.$name_mi; } $name_full .= ' '.$name_last; if (isset($suffix) && $suffix != 0) { $name_full .= ', '.$suffix; } if (isset($designations) && $designations != '') { $name_full .= ', '.$designations; } if (isset($practice_name) && $practice_name == '') { $practice = $name_full; } else { $practice = ''.$practice_name.'
'.$name_full; } $nameURL = str_replace(' ','_',$nameURL); //$name = str_replace('&','+',$name); $cityURL = str_replace(' ','_',$city); $stateURL = str_replace(' ','_',$state); $specialtyURL = str_replace(' ','_',$specialty1); $getprofileURL = '/dentist/'.$profile_id.'/'.$stateURL.'/'.$cityURL.'/'.$specialtyURL.'/'.$nameURL; //check for jobs $q = "SELECT * FROM azdp_jobs WHERE job_practice_id = $practice_id AND job_status = 1"; $rows = mysqli_query($conn, $q) or die("error: not able to retrieve job status ".mysqli_error($conn)); $num_jobs = mysqli_num_rows($rows); ?>

Featured Provider

0 ORDER BY profile_id DESC LIMIT 18"; $rows = mysqli_query($conn, $sqlr) or die("couldnt insert".mysqli_error($conn)); ?>

Latest Additions