<?php
$conf
['DB_USER'] = 'user';
$conf
['DB_PWD'] = 'pwd';
$conf
['DB_NAME'] = 'dbname';
$conn
= mysql_connect('localhost',
$conf
['DB_USER'],
$conf
['DB_PWD']);
if
(!
$conn
) {
echo
'数据库连接错误!';
}
mysql_set_charset('utf8',
$conn
);
mysql_select_db(
$conf
['DB_NAME']);
$sql2
= 'select catid,catname from v9_category';
$cat
= mysql_query(
$sql2
);
while
(
$catrow
=mysql_fetch_array(
$cat
)) {
echo
$catrow
['catname'].'</br>';
$sql
= '(select title,url from v9_news where catid='.
$catrow
[
"catid"
].' order by id desc)
UNION (select title,url from v9_product where catid='.
$catrow
[
"catid"
].' order by id desc)';
$result
= mysql_query(
$sql
);
while
(
$row
=mysql_fetch_array(
$result
)) {
echo
$row
['url'].
"</br>"
;
}
}
?>