<?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='
);