Treatment Center Search Results

Below are the search results. If the results didn't match what you were looking for then click here to search again by Zip Code / Postal or by State and City.

" . $zipcode . "
"; $radius = $_GET['radius']; //print "
" . $radius . "
"; $list_length = 25; $result = db_query('SELECT state, latitude, longitude FROM {zipcodes} WHERE zip = "%s" LIMIT 1', $zipcode); while ($nextrow = db_fetch_object($result)) { $state = $nextrow->state; $lat = (float) $nextrow->latitude; $lng = (float) $nextrow->longitude; $lng_min = $lng - $radius / abs(cos(deg2rad($lat)) * 69); $lng_max = $lng + $radius / abs(cos(deg2rad($lat)) * 69); $lat_min = $lat - ($radius / 69); $lat_max = $lat + ($radius / 69); //print $nextrow->state; if ($state) { $query = 'SELECT nid FROM {content_type_treatment_center} WHERE (field_listing_type_value = "0Platinum" AND field_state_value = "' . $state . '") OR field_postal_code_value IN (SELECT zip FROM {zipcodes} WHERE (longitude BETWEEN ' . $lng_min . ' AND ' . $lng_max . ') AND (latitude BETWEEN ' . $lat_min . ' and ' . $lat_max . ')) ORDER BY field_listing_type_value ASC'; $result = pager_query($query, $list_length, 0, NULL); //print '

Platinum Listings

'; while ($tempnodeobject = db_fetch_object($result)) { $nodeobject = node_load(array('nid'=>$tempnodeobject->nid)); //print "
" . print_r($nodeobject, TRUE) . "
"; $imagepath = 'treatment center'; if($nodeobject->field_address2[0]['value']){ $address2 = ' ' . $nodeobject->field_address2[0]['value']; }else{ $address2 = ''; } if ($nodeobject->field_listing_type[0]['value'] == '0Platinum') { if ($nodeobject->field_website[0]['value'] != 'N/A') { $theurl = $nodeobject->field_website[0]['value']; } else { $theurl = $nodeobject->path; } print '
' . l($nodeobject->title, $theurl) . '
' . l($imagepath, $theurl, array('html' => TRUE)) . '

' . $nodeobject->field_teaser[0]['value'] . ' ' . l('Complete Details', $nodeobject->path) . '

' . $nodeobject->field_address1[0]['value'] . ' ' . $address2 . '
' . $nodeobject->field_city[0]['value'] . ', ' . $nodeobject->field_state[0]['value'] . ' ' . $nodeobject->field_postal_code[0]['value'] . '
' . $nodeobject->field_phone[0]['value'] . '
' . l('Visit Website', $theurl) . '
'; } if ($nodeobject->field_listing_type[0]['value'] == '1Gold') { if ($nodeobject->field_website[0]['value'] != 'N/A') { $theurl = $nodeobject->field_website[0]['value']; } else { $theurl = $nodeobject->path; } print '
' . l($nodeobject->title, $theurl) . '
' . l($imagepath, $theurl, array('html' => TRUE)) . '

' . $nodeobject->field_teaser[0]['value'] . ' ' . l('Complete Details', $nodeobject->path) . '

' . $nodeobject->field_address1[0]['value'] . ' ' . $address2 . '
' . $nodeobject->field_city[0]['value'] . ', ' . $nodeobject->field_state[0]['value'] . ' ' . $nodeobject->field_postal_code[0]['value'] . '
' . $nodeobject->field_phone[0]['value'] . '
' . l('Visit Website', $theurl) . '
'; } if ($nodeobject->field_listing_type[0]['value'] == '2Silver') { if ($nodeobject->field_website[0]['value'] != 'N/A') { $theurl = $nodeobject->field_website[0]['value']; } else { $theurl = $nodeobject->path; } print '
' . l($nodeobject->title, $theurl) . '

' . $nodeobject->field_teaser[0]['value'] . ' ' . l('Complete Details', $nodeobject->path) . '

' . $nodeobject->field_address1[0]['value'] . ' ' . $address2 . '
' . $nodeobject->field_city[0]['value'] . ', ' . $nodeobject->field_state[0]['value'] . ' ' . $nodeobject->field_postal_code[0]['value'] . '
' . $nodeobject->field_phone[0]['value'] . '
' . l('Visit Website', $theurl) . '
'; } if ($nodeobject->field_listing_type[0]['value'] == '3Free') { print '
' . $nodeobject->title . '
' . $nodeobject->field_address1[0]['value'] . ' ' . $address2 . '
' . $nodeobject->field_city[0]['value'] . ', ' . $nodeobject->field_state[0]['value'] . ' ' . $nodeobject->field_postal_code[0]['value'] . '
'; } } if ($loop_count < $list_length) $loop_count += 1; print theme('pager', $loop_count); } } } ?>

Addiction Support Groups

SupportGroups.com is for individuals, friends and families who are looking to connect during life's challenging times. Share personal experiences, evaluate information and get support during times of need, illness, treatment or recovery.

disclaimer

Call now for immediate help: (844) 630-4673