| [ Index ] |
PHP Cross Reference of Drupal 6 (heimberg) |
[Summary view] [Print] [Text view]
1 <?php 2 require_once ('DbLib-12.php'); 3 $dbCat = &new DbLibMySQL; 4 $dbCat->OpenConnection(); 5 $sqlCat = "SELECT id, name FROM category WHERE parentCatId is null AND (state='AZ' OR state='BOTH' OR state='') ORDER BY name "; 6 $dbCat->Query($sqlCat); 7 8 $dbSubs = &new DbLibMySQL; 9 $dbSubs->OpenConnection(); 10 $dbOrgs = &new DbLibMySQL; 11 $dbOrgs->OpenConnection(); 12 ?> 13 14 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/resources.dwt" codeOutsideHTMLIsLocked="false" --> 15 <head> 16 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> 17 <!-- InstanceBeginEditable name="doctitle" --> 18 <title>THE GUIDE: Resources for the Disabilities Community</title> 19 <meta name="description" content="The Guide offers links to a myriad of disability related web sites" /> 20 <meta name="keywords" content="disability links, website for disabled persons, disability resources, disabilities, adoption, aging, accessibility, animal programs, arts, assistive technology, bereavement, consumer advocacy, Early Intervention, Education, Resource, Employment, Family Resources, Health & Insurance Services, Housing, Independent Living, Legal, Listserves, Bulletin Boards, Medical Resources, Mobility Resources, Parks & Recreation, Publications, Events, Regional Centers, Rehabilitation, Support Groups, Alzheimers, Amputee, Auditory Disorders, Birth Defects, Brain Injuries, Cardio-Respiratory Disorders, Circulatory Metabolic Disorders, Cleft Palate, Developmental Disorders, Diabetes, Help Lines, Neuro-Muscular Disorders, Organ Disorders, Ostomy , Pain, Speech, Language, Spinal Cord, Injuries, Disorders, Spine Joint Disorders, Vision Disorders, Theme Parks, Toys, Video Games, Transportation, Manufacturers, Adapters, Rebates, Rentals, Ventilator, Feeding Tube, Resources, Wills, Trusts, Money Management" /> 21 22 <!-- InstanceEndEditable --> 23 <!-- We put in three stylesheets because that's how the JS function increases the font size. --> 24 <link href="../css/styles_plus_one.css" rel="stylesheet" type="text/css" /> 25 <link href="../css/styles_plus_two.css" rel="stylesheet" type="text/css" /> 26 <link href="../css/styles.css" rel="stylesheet" type="text/css" /> 27 <script src="../Scripts/AC_RunActiveContent.js" type="text/javascript"></script> 28 <script src="../Scripts/utility.js" type="text/javascript"></script> 29 30 <!-- InstanceBeginEditable name="head" --> 31 32 <!-- InstanceEndEditable --> 33 </head> 34 35 <body onload="checkCSS();"> 36 <a name="top" id="top"></a> 37 <div id="wrapper"> 38 <div id="topBar"><a href="../site_search.html">Search</a><a href="../faqs.html">FAQs</a><a href="../sitemap.html">Site Map</a></div> 39 <div id="headerBar"><script type="text/javascript"> 40 AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','770','height','120','src','../swf/header2','quality','high','pluginspage','http://www.macromedia.com/go/getflashplayer','movie','../swf/header2' ); //end AC code 41 </script><noscript> 42 <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="770" height="120"> 43 <param name="movie" value="../swf/header2.swf" /> 44 <param name="quality" value="high" /> 45 <embed src="../swf/header2.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="770" height="120"></embed> 46 </object></noscript> 47 </div> 48 <div id="navBar"> 49 <a href="../index.html" class="menuItem">Home</a> 50 <a href="../firm/our_firm.html" class="menuItem">Our Firm</a> 51 <a href="../results/verdicts_settlements.html" class="menuItem">Verdicts & Settlements</a> 52 <a href="../practices/our_practices.html" class="menuItem">Our Practices</a> 53 <a href="../attorneys/attorneys_staff.html" class="menuItem">Our Attorneys</a> 54 <a href="resources.html" class="navOn">Resources</a> 55 <a href="../community/community_outreach.html" class="menuItem">Community Outreach</a> 56 <a href="../contact/contact.html" class="menuItem">Contact Us</a> 57 58 59 </div> 60 61 62 <div id="mainBody"> 63 <table width="100%" border="0" cellspacing="0" cellpadding="0"> 64 <tr> 65 <td id="leftNav"> 66 <!-- InstanceBeginEditable name="leftRegion" --> 67 <a href="legal_links.html" class="subNav">Legal Links</a> 68 69 <p> </p> 70 71 <?php 72 while($dbCat->GetNextRecord()) { ?> 73 <?php 74 $str = $dbCat->GetField('name'); 75 76 $str = strtolower($str); 77 $str = ucwords($str); 78 ?> 79 <a href="#<?php echo $dbCat->GetField('id');?>" class="subNav"><?php echo $str;?></a> 80 <?php 81 ///Begin 82 $sqlSubs = "select id, name from category where parentCatId = ". $dbCat->GetField('id')." AND (state='AZ' OR state='BOTH' OR state='') ORDER BY name"; 83 $dbSubs->Query($sqlSubs); 84 while($dbSubs->GetNextRecord()) { ?> 85 <?php 86 $str = $dbSubs->GetField('name'); 87 88 $parentId = $dbCat->GetField('parentCatId'); 89 90 $str = strtolower($str); 91 $str = ucwords($str); 92 ?> 93 <a href="#<?php echo $dbSubs->GetField('id');?>" class="subSubNav"><?php echo $str;?></a> 94 <?php } ?> 95 <?php 96 } 97 $dbCat->ResetRecordSet(); 98 ?> 99 <!-- InstanceEndEditable --> </td> 100 <td id="contentArea"> 101 <p style="text-align:right;"><a href="#" onClick="eMailPage();"><img src="../images/emailicon.gif" alt="Email" width="17" height="11" border="0" />E-mail this page</a> | <a href="#" onClick="window.print();"><img src="../images/printicon.gif" alt="print" width="19" height="14" border="0" />Print this page</a> | Text size: <a href="#" onClick="changeCSS('base');"><img src="../images/A1.gif" alt="small" width="12" height="17" border="0" /></a> <a href="#" onClick="changeCSS('plus1');"><img src="../images/A2.gif" alt="medium" width="15" height="17" border="0" /></a> <a href="#" onClick="changeCSS('plus2');"><img src="../images/A3.gif" alt="large" width="19" height="17" border="0" /></a></p> 102 103 <!-- InstanceBeginEditable name="contentRegion" --> 104 <h1>THE GUIDE: <em>Arizona Resources for the Disabilities Community</em></h1> 105 <p><strong>The Guide: <em>Resources for the Disabilities Community</em></strong> is designed to assist people who are 106 disabled and their family and friends to find services and resources to improve their lives. 107 We hope you find it useful.</p> 108 <p>The Guide is a work-in-progress. If you know of a resource that would be of interest to the 109 disabilities community, please e-mail it to <a href="mailto:gwilson@heimberglaw.com">gwilson@heimberglaw.com</a>.</p> 110 <p>Many national organizations have local chapters; you may find this information on the 111 web sites listed in The Guide; if not, ask for contact information when you call or e-mail 112 the national organization.</p> 113 <p>If someone you know would like a copy of The Guide, please refer them to our web site, 114 <a href="http://www.heimberglaw.com">www.heimberglaw.com</a>, to download a copy. </p> 115 <p>The Heimberg Law firm has long championed the most 116 vulnerable members of our society -- those who have been severely, permanently and wrongly injured. Steve 117 (who is a doctor as well as a lawyer), leads a legal team dedicated to battling wrongdoers, whether 118 HMOs, hospitals, nursing homes, medical personnel, insurance companies, pharmaceutical companies, 119 reckless drivers, manufacturers of defective or dangerous products, or others.</p> 120 <p>Steve's commitment to the disabilities community extends past the walls of the courtroom and into 121 their personal lives through their support of Shane's Inspiration, WYNGS and other charitable organizations.</p> 122 <p>In essence, Heimberg Law Group, LLP aggressively and ethically pursues the best possible lives for those who 123 come to them for help.</p> 124 125 <?php 126 127 while($dbCat->GetNextRecord()) { 128 129 ?> 130 <p><a href="#top">back to top</a></p> 131 </blockquote><h2><a name="<?php echo $dbCat->GetField('id');?>" id="<?php echo $dbCat->GetField('name');?>"></a> 132 <?php echo strtoupper($dbCat->GetField('name'));?></h2><blockquote> 133 134 <?php 135 if ($dbCat->GetField('name') == 'SUPPORT GROUPS') 136 { 137 ?> 138 139 <p class="indented">Most national associations have local chapters that can provide you access to local support and resources. <br /> 140 <br /> 141 Sometimes local chapters are listed on the national web site. If you can't find a local chapter, e-mail or call the national chapter and ask if there is a local chapter near you.<br /> 142 <br /> 143 If there is not a local chapter near you, consider starting one. The national organization is usually willing to help you with advice and information on how to start a local chapter.</p> 144 <?php } ?> 145 <?php 146 147 //display all orgs for this category 148 149 $sqlOrgs = "SELECT * FROM organization WHERE (state='AZ' OR state='BOTH') AND catId = ". $dbCat->GetField('id')." ORDER BY name"; 150 151 $dbOrgs->Query($sqlOrgs); 152 while($dbOrgs->GetNextRecord()) { ?> 153 <h3><?php echo $dbOrgs->GetField('name');?></h3> 154 <p class="indented"> 155 <?php 156 $description = $dbOrgs->GetField('description'); 157 158 if (!empty($description)) 159 { 160 echo "$description<br/>"; 161 } 162 163 $phone = $dbOrgs->GetField('phone'); 164 165 if (!empty($phone)) 166 { 167 echo "$phone "; 168 } 169 ?> 170 <a href="http://<?php echo $dbOrgs->GetField('url');?>" target="_blank" rel="nofollow"><?php echo $dbOrgs->GetField('url');?></a></p> 171 <?php } 172 173 //display all the subcategories for this category 174 175 $sqlSubs = "select id, name from category where parentCatId = ". $dbCat->GetField('id')." AND (state='AZ' OR state='BOTH' OR state='') ORDER BY name"; 176 $dbSubs->Query($sqlSubs); 177 while($dbSubs->GetNextRecord()) { ?> 178 <h2><a name="<?php echo $dbSubs->GetField('id');?>"><?php echo $dbSubs->GetField('name'); ?></h2> 179 180 <?php 181 182 //display the orgs for the subcategory 183 184 $sqlOrgs = "SELECT * FROM organization WHERE catId = ". $dbSubs->GetField('id')." AND (state='AZ' OR state='BOTH' OR state='') ORDER BY name"; 185 $dbOrgs->Query($sqlOrgs); 186 while($dbOrgs->GetNextRecord()) { ?> 187 <blockquote><h3><?php echo $dbOrgs->GetField('name');?></h3> 188 <p class="indented"> 189 <?php 190 $description = $dbOrgs->GetField('description'); 191 192 if (!empty($description)) 193 { 194 echo "$description<br/>"; 195 } 196 197 $phone = $dbOrgs->GetField('phone'); 198 199 if (!empty($phone)) 200 { 201 echo "$phone "; 202 } 203 ?> 204 205 <a href="http://<?php echo $dbOrgs->GetField('url');?>" target="_blank" rel="nofollow"><?php echo $dbOrgs->GetField('url');?></a></p></blockquote> 206 <?php } ?> <blockquote><p><a href="#top">back to top</a></p></blockquote> 207 <?php } 208 } 209 ?> 210 <!-- InstanceEndEditable --></td> 211 </tr> 212 </table> 213 </div> 214 <div id="addressBar">1801 Century Park East - Suite 1920 - Los Angeles CA 90067 | TEL: (310) 553-1799 | Toll-Free: (800) 425-5557<br /> 215 2700 N. Central Avenue - Suite 1400 - Phoenix AZ 85004 | TEL: (602) 285-4406 | Toll-Free: (800) 425-5557</div> 216 <div id="footerBar"> 217 <table width="100%" border="0" cellspacing="0" cellpadding="0"> 218 <tr> 219 <td style="padding-left:12px">© Copyright 2006 Heimberg Law Group, LLP. All Rights Reserved. </td> 220 <td align="right" style="padding-right:12px"><a href="../disclaimer.html">Disclaimer</a></td> 221 </tr> 222 </table> 223 </div> 224 </div> 225 </body> 226 <!-- InstanceEnd --></html>
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
| Generated: Wed Mar 23 13:22:29 2011 | Cross-referenced by PHPXref 0.7 |