PHP Accordion by grouping

Report · Dec 10, 2010

Good Day,

I would like to create a spry accordion from a Recordset.

My recordset has a category and exception. So there could be 5 rows with the same category.

I would like to create an accordion that would show the category once and the content would list each exception within that category.

Just not sure how to creat the loop for this as I want it to loop on change of category.

Any tips is greatly appreciated!

Report · Dec 11, 2010

Ok, figured out a solution with two queries.

1st query contains just a query grouping all the categories together. I then run a loop on the accordion, tab section to list each category.

Inside that loop I run another query that is equal to the category in the loop. From there I run another loop in the content section that displays all the results of that category.

Report · Apr 26, 2011

Hey nstratton. Thanks for that info. I also want to incorporate my Recordsets into accordions. Could you please send me the coding to do so? Your explanation is a bit too advanced for me at this stage. Much appreciated. G

Report · Apr 26, 2011

I am trying to put the code, but it is converting to HTML. Give me a few minutes to figure that out.

Report · Apr 26, 2011

<?php

$i=0;

$j=0;

?>

</p>

<strong>Exception Categories:</strong>

<?php do { ?>

<?php

$category=$row_Recordset4['category'];

mysql_select_db($database_loanauditv2, $loanauditv2);

$query_Recordset5 = "SELECT * FROM exception_list WHERE category = '$category' Order by exception ASC";

$Recordset5 = mysql_query($query_Recordset5, $loanauditv2) or die(mysql_error());

$row_Recordset5 = mysql_fetch_assoc($Recordset5);

$totalRows_Recordset5 = mysql_num_rows($Recordset5);

?>

<tr>

<td width="50%"><strong>Exception</strong></td>

<td width="15%"><strong>Action Needed</strong></td>

<td width="30%"><strong>Notes</strong></td>

</tr>

<?php do {?>

<tr <?php

// technocurve arc 3 php bv block2/3 start

echo " style=\"background-color:$color\"";

// technocurve arc 3 php bv block2/3 end

?>>

</div>

</label></td>

<td><p>

</select>

<br>

</p></td>

</tr>

<?php

// technocurve arc 3 php bv block3/3 start

if ($color == $color1) {

$color = $color2;

} else {

$color = $color1;

}

// technocurve arc 3 php bv block3/3 end

?>

<?php } while ($row_Recordset5 = mysql_fetch_assoc($Recordset5)); ?>

</table>

</div>

<?php } while ($row_Recordset4 = mysql_fetch_assoc($Recordset4)); ?>

</div>

            <p>

    </p>
          <input type="hidden" name="MM_insert" value="form1">
          <br>
          </form>
        <p class="just"><br>
            <br>
        <script language="JavaScript" type="text/javascript">
var cpg = new Spry.Widget.CollapsiblePanelGroup("CollapsiblePanelGroup5", { contentIsOpen: false });
</script>