PHP全路径无限分类导航LINK代码实现

<?php

/**
 * @param php全路径无限分类
 */

include('db.inc.php');
function getpathcate($cateid){
    $sql = "select * ,concat(path,',',id) fullpath from likecate where id = $cateid";
    $res = mysql_query($sql);
    $row = mysql_fetch_assoc($res);
    $ids = $row['fullpath'];
    $sql = "select * from likecate where id in ($ids) orders by id asc";
    $res = mysql_query($sql);
    $result = array();
    while ($row = mysql_fetch_assoc($res)) {
        $result[] = $row;
    }
    return $result;
}

function displaypath($cateid,$link='cate.php?cid='){
    $res = getpathcate($cateid);
    $str = '';
    foreach ($res as $key => $value) {
        $str .= "<a href ='{$link}{$value['id']}'>{$value['catename']}</a>";
    }

}

echo displaypath(4,'cate.php?p=1&cid=');