Accordion List of Office Locations from recordset (php & mysql)

so have list of office locations hard coded webpage , need have data pulled in database. have created recordset , can pull data need. have been struggling on how data formated each office location has own accordion menu. in db have office location table locationid set each office. thinking is... setting each accordion id pull in locationid db.

 

i have recordset pulling in 30 office locations @ once. thought including clause sql statement -

officelocations_tbl.locationid = "21"

except need seperate recordset each location think.

 

so here sql statement: -- (again without adding clause above)--

 

select officelocations_tbl.*,city_tbl.*, state_tbl.* , contact1.firstname c1firstname, contact1.lastname c1lastname, contact1.middleinitial c1middleinitial, contact1.suffix c1suffix, contact1.accredations c1accredations, contact1.phone c1phone, contact1.faxnumber c1faxnumber, contact2.firstname c2firstname, contact2.lastname c2lastname, contact2.middleinitial c2middleinitial, contact2.suffix c2suffix, contact2.accredations c2accredations, contact2.phone c2phone, contact2.faxnumber c2faxnumber, partner.firstname c3firstname, partner.lastname c3lastname, partner.middleinitial c3middleinitial, partner.suffix c3suffix, partner.accredations c3accredations, partner.phone c3phone, partner.faxnumber c3faxnumber officelocations_tbl join city_tbl on (officelocations_tbl.cityid = city_tbl.cityid) left outer join state_tbl on (officelocations_tbl.stateid = state_tbl.stateid) left outer join staff_tbl contact1 on (contact1.staffid = officelocations_tbl.contact1) left outer join staff_tbl contact2 on (contact2.staffid = officelocations_tbl.contact2) left outer join staff_tbl partner on (partner.staffid = officelocations_tbl.partner)

 

 

here code 1 of accordions:

 

<li><a href="#" class="opener"><strong>some office name</strong></a> <div class="slide-holder"> <div class="slide">   <!-- ***************** - start contact table - ***************** -->   <div class="contact_table grey_table">       <div class="border">          <!-- featured column -->              <div class="column featured">                <div class="included">                   <ul>                       <li>some address</li>                       <li>city, state zip</li>                       <br />                       <!--<li class="email"><strong>contact: </strong><a href="mailto:someperson@somedomain.com">john doe</a></li>                       <li>tel: 000-000-0000 / fax: 000-000-0000</li>                       <br />                       <li class="email"><strong>contact: </strong><a href="mailto:someperson@somedomain.com">john doe</a></li>                       <li>tel: 000-000-0000 / fax: 000-000-0000</li>                        <br />-->                       <li class="email"><strong>partner: </strong><a href="mailto:someperson@somedomain.com">john doe</a></li>                       <li>tel: 000-000-0000 / fax: 000-000-0000</li>                        <br />                   </ul>               </div>                 </div>           <!-- end featured column -->       </div>   </div> <!-- ***************** - end contact table - ***************** -->    </div></div></li>  

 

can me out here?

 

message edited by: maxtal

moved developing server-side applications in dreamweaver forum.

 

this sounds simple repeat region. wrap basic accordion in repeat region (in other words loop), , populate accordion database results.

More discussions in Develop server-side applications in Dreamweaver

adobe