TalkPHP - View Single Post

maZtah · 02-27-2008, 10:43 AM

Okay, let's clearify with a working example (the ugly way with more than one queries):

PHP Code:


			
            <div id="nav">

<?php

$szQuery = "SELECT id, name FROM menu WHERE parentId = 0 ORDER BY rank ASC";

$pResult = mysql_query($szQuery) or die(mysql_error());



if (mysql_numrows($pResult))

{ ?>

                <ul>

<?php

    while($aRow = mysql_fetch_array($pResult))

    { ?>

                    <li<?php echo ($aRow['id'] == $iMenu ? ' class="active"' : ''); ?>>

                        <a href="index.php?menuid=<?php echo $aRow['id']; ?>"><?php echo $aRow['name']; ?></a>

<?php    $szSubQuery = "SELECT id, name FROM menu WHERE parentId = {$aRow['id']} ORDER BY rank ASC";

        $pSubResult = mysql_query($szSubQuery) or die(mysql_error());

        

        if (mysql_numrows($pSubResult))

        { ?>

                    

                        <ul>

<?php        while($aSubRow = mysql_fetch_array($pSubResult))

            { ?>

                            <li<?php echo ($aSubRow['id'] == $iMenu ? ' class="active"' : ''); ?>><a href="index.php?menuid=<?php echo $aSubRow['id']; ?>"><?php echo $aSubRow['name']; ?></a></li>

<?php        } ?>

                        </ul>

                    </li>

<?php    }

        else

        { ?>

                    </li>

<?php    }

    } ?>

                    <li<?php echo ($szTitle == 'Contact' ? ' class="active"' : ''); ?>>

                        <a href="contact.php">Contact</a>

                    </li>

                </ul>

<?php

    } ?>

            </div>

How would I do this with only one query? :)

02-27-2008, 10:43 AM	#2 (permalink)
maZtah The Acquainted Join Date: Oct 2007 Posts: 170 Thanks: 18	Okay, let's clearify with a working example (the ugly way with more than one queries): PHP Code: <div id="nav"> <?php $szQuery = "SELECT id, name FROM menu WHERE parentId = 0 ORDER BY rank ASC"; $pResult = mysql_query($szQuery) or die(mysql_error()); if (mysql_numrows($pResult)) { ?> <ul> <?php while($aRow = mysql_fetch_array($pResult)) { ?> <li<?php echo ($aRow['id'] == $iMenu ? ' class="active"' : ''); ?>> <a href="index.php?menuid=<?php echo $aRow['id']; ?>"><?php echo $aRow['name']; ?></a> <?php $szSubQuery = "SELECT id, name FROM menu WHERE parentId = {$aRow['id']} ORDER BY rank ASC"; $pSubResult = mysql_query($szSubQuery) or die(mysql_error()); if (mysql_numrows($pSubResult)) { ?> <ul> <?php while($aSubRow = mysql_fetch_array($pSubResult)) { ?> <li<?php echo ($aSubRow['id'] == $iMenu ? ' class="active"' : ''); ?>><a href="index.php?menuid=<?php echo $aSubRow['id']; ?>"><?php echo $aSubRow['name']; ?></a></li> <?php } ?> </ul> </li> <?php } else { ?> </li> <?php } } ?> <li<?php echo ($szTitle == 'Contact' ? ' class="active"' : ''); ?>> <a href="contact.php">Contact</a> </li> </ul> <?php } ?> </div> How would I do this with only one query? :)