Public feed #724906

Stuff

public php v1 · immutable
Raw Edit
·published 2007-10-03 23:14 UTC
rendered paste body
<?php$query = "select * from cms_categories where name != 'TOP'";$result = mysql_query($query);$myrow = mysql_fetch_array($result);if($myrow["catorderby"] == "asc" || $myrow["catorderby"] == "desc")   $query .= " order by name ".$myrow["catorderby"];else   $query .= " order by catorderby asc";$categories = mysql_query($query);while ($cate = mysql_fetch_array($categories)) {        echo "<div id=\"links\">     <ul id=\"links\">";	$query = "select * from cms_menu where `category`='".$cate["id"]."' order by ";    	if($cate["orderby"] == "custom")		$query .= "`orderby` asc";	else		$query .= "`name` ".$cate["orderby"];	$menu_query = mysql_query($query) or die(mysql_error());  while ($menu = mysql_fetch_array($menu_query)) {$site_url = "http://www.designsbyerikamarie.com/";    if (substr($menu["link"],0,4) == "http") {	echo "&middot;<a href=\"".$menu["link"]."\" title=\"".$menu["description"]."\" target=\"".$menu["target"]."\">".$menu["name"]."</a>";    } else {	$category = strtolower(str_replace(' ', '-', $cate['name']))."/";	echo "&middot;<a href=\"$site_url".$category.$menu["alias"].".html\" title=\"".$menu["description"]."\" target=\"".$menu["target"]."\">".$menu["name"]."</a>";    }  }echo"</ul></div>";}?>