Rate this article

Is it possible to have dynamic data extracted from a database, displayed as menu items

Rating: 5.0/5 (4 votes cast)

Yes it is possible.

Follow the steps as detailed below:

Create your menu as usual
Create the record-set that you want to display in the menu
Change to "Code View" and search for the lines where you want the dynamic table to appear
The code should look similar to this

       <li> <a href="#" title="Product Articles">Articles</a>
            <ul>
                 <li> <a href="#" title="MX CSS Menus">MX CSS Nenus</a></li>
            </ul>
       </li>

Now create the repeat region
The code should look similar to this

<table border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td>prod_id</td>
    <td>prod_name</td>
  </tr>
  <?php do { ?>
  <tr>
    <td><?php echo $row_rs_products['prod_id']; ?></td>
    <td><?php echo $row_rs_products['prod_name']; ?></td>
  </tr>
  <?php } while ($row_rs_products = mysql_fetch_assoc($rs_products)); ?>
</table>

Now delete all the tags that has something to do with the table
It should then look like this

  <?php do { ?>
   <?php echo $row_rs_products['prod_name']; ?>
  <?php } while ($row_rs_products = mysql_fetch_assoc($rs_products)); ?>

You now have a "table-less" dynamic table

Now simply integrate this into your menu
It could look something like this

        <li> <a href="#" title="Products Articles">Articles</a>
            <ul>
                <?php do { ?>
                          <li> <a href="../forum.php?pro_id=<?php echo $row_rs_products['prod_id']; ?>" title="<?php echo $row_rs_products['prod_name']; ?> Forum"><?php echo $row_rs_products['prod_name']; ?></a> </li>
                <?php } while ($row_rs_products = mysql_fetch_assoc($rs_products)); ?>          
            </ul>
        </li>

This is the exact code for the "Article" menu on this site.
The only difference is the code has been optimised for SEO purposes to point to an html file instead of a php file

Adobe

Free PositiveSSL and WhoisGuard with Every Domain Purchase
ionCube Online PHP Encoder
XMS Systems

Although we try to ensure all the articles submitted are valid it is your responsibility to make sure you have backups before you use these suggestions on your pc or websites.
We do not take any responsibility for any data-loss, loss in functionality or any problem that might arise in what-ever way or form by making use of the information on this site.

"Friends of Interakt" has no connection to the Adobe Interakt Company