You'll want to change the line that reads: > print "\t$url\n"; to write a link; Something like the following: > echo "\t<a href=\"$url\" title=\"$value\">$value</a><br />\n";
You might want to consider rendering your links as a list, you can then use CSS to style this up in what ever fashion you desire. (Here's some examples: http://css.maxdesign.com.au/listamatic/) Do do this you'll want to output the '<ul>' and '</ul>' before and after your inner for loop, respectively; and then add '<li>' and '</li>' around your link. Enjoy, Phill On 07/10/06, stephendowney2003 <[EMAIL PROTECTED]> wrote: > > Hello Everyone, > > I am a newbie and have been reading, experimenting, and building a > database driven website about my favorite topic...beer. > > I am trying to create a database driven navigation menu that only > displays certain menu options according to their authority. I have > been receiving a little help from a friend at work but it is the > weekend and I am still in need of help. > > My code displays the menu but I don't know how to get teh > MenuSelectionName items to be hyperlinks. > > Below is the code and the tables I am using. Your help will be > greatly appreciated. > > Stephen > > Here is what I would like to appear... > > Menu > MenuTopic > MenuSelectionName > MenuSelectionName > MenuTopic > MenuSelectionName > MenuTopic > MenuSelectionName > MenuSelectionName > > It would look like this on the site... > > Education > Brewing 101 > Tasting How To > Members Only > Add a Beer > Administration > Add A Beer Verification > Member Accounts Screen > > Here is the code I am having a problem with... > > <?php > > include("Hops.inc"); > > $connection = mysql_connect($host, $user,$password) > or die ("Couldn't connect to server."); > $db = mysql_select_db($database, $connection) > or die ("Couldn't select database."); > > $query = "SELECT MenuTopic, MenuSelectionName, MenuURL, > MenuAuthLevel FROM MenuTable ORDER BY MenuAuthLevel"; > $result = mysql_query($query) or die ("Query failed"); > > /* creates an empty array called $menu. */ > $menu = array(); > > if( $result ) > { > while ($row = mysql_fetch_row($result)) > { > if( $menu[ "$row[0]" ] == null ) > { > $urls = array(); > } > else > { > $urls = $menu[ "$row[0]" ]; > } > array_push( $urls, $row[1] ); > $menu[ "$row[0]" ] = $urls; > } > } > > > else > { > print "Mysql error: " . mysql_error($result); > } > > foreach( $menu as $category => $value ) > { > print "$category\n"; > echo "<br>"; > foreach( $value as $url ) > { > echo " "; > print "\t$url\n"; > echo "<br>"; > } > } > ?> > > Tables > > MenuTable > > MenuID INT(3) NOT NULL > AUTO_INCREMENT, > MenuSelectionName VARCHAR(50) NOT NULL, > MenuURL VARCHAR(50) NOT NULL, > MenuTopic VARCHAR(25) NOT NULL, > MenuAuthLevel INT(2) NOT NULL, > > Members > > FirstName VARCHAR(50) NOT NULL, > LastName VARCHAR(50) NOT NULL, > CreateDate DATETIME NOT NULL, > Street VARCHAR(50), > City VARCHAR(50), > State CHAR(2), > Zip CHAR(10), > Email VARCHAR(50), > UserID VARCHAR(20) NOT NULL, > Password CHAR(15) NOT NULL, > PasswordHint VARCHAR(100) NOT NULL, > PasswordHintAns VARCHAR(50) NOT NULL, > Authority CHAR(2) Default "2", > Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/php-list/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
