Date: 05/27/05 (Web Development)    Keywords: php, mysql, database, sql, web

I'm working away at this PHP + MySQL stuff...

Now I have two tables - links and linkcats. Links is a list of links that will be displayed on the Employee Resources page. Linkcats is a list of the categories under which these links will fall - Intranet Websites, Internet Websites, and Employee Resources. I would like to be able to dynamically display the link categories with the appropriate links from the links table under each category. I got it to work (kind of), but it loops through the SQL statement to display the actual links however many entries there are in the categories table.

You can see what I'm talking about here:
http://www.shifuimam.com/php_tutorials/database_trial/www/mclinks.php

This is my code, along with the descriptions of the two tables:
http://mypage.iu.edu/~cstrodtb/livejournal/mclinks.txt

Any help is appreciated.

x-posted to webdesign.

Source: http://www.livejournal.com/community/webdev/204666.html