how retrieve catergory form database for menulist

This site is best viewed in a modern browser with JavaScript enabled.

how retrieve catergory form database for menulist

praban

hi friends
im basic develop i have i problem ,

i'm creating the website for upload ads but. i put hard code to the menu.
i need the menu list should directly come from database.
i try some code but that are retrieve the data form database
"but it retrieve automatically link the other page. "

Strider64

I do something like this in php, I don't know if this is what you mean?

function php_navigation($nav_page, $page_set) {

	// Format for php_navigation 
	// <ul>
	//    <li><a href="{link}">Name of Link</a></li>
	// </ul>

	global $db;		

	$query = "SELECT id, blog_name FROM pages ORDER BY new_blog_date ASC LIMIT 25";

	$output = "<ul>";
	if ($result = mysqli_query($db, $query)) {
	    while ($page = mysqli_fetch_array($result)) {
	        $output .= "<li><a href=\"" . $nav_page . "?page=" . urlencode($page["id"]) . "\">";

		   if ($page_set == $page['id']) {
		   	   $output .= "<span class=\"selected\" >{$page["blog_name"]}</span>";	   
		   } else {
			   $output .= "{$page["blog_name"]}";
		   }		   

		   $output .= "</a></li>";			   
	    }
	    /* free result set */
	    mysqli_free_result($result);		    
	}

	$output .= "</ul>";		

	return $output;
}

praban

thank you

Flack

If you're working in ASP.NET, you can put a menu control, and write the query as a stored procedure then stick a datasource on the page and hook them all up. For menus like this that are unlikely to change frequently but appear on all pages, you should also use caching, which can easily be turned on in the control in .net. If you're serving 10,000 pages per day, you don't want to be making 10,000 round trips to the db to get exactly the same data when you can do just one.