对高手来应该不算难!文章分类 及文章标题 分别为2个表中取出的数据
$cat = array(
// --------------------
array( "c" => "文章分类1",
"list" => array(
array("t" => "文章标题1"),
array("t" => "文章标题2"),
array("t" => "文章标题3"),
array("t" => "文章标题4"),
array("t" => "文章标题5")
)
),
// ---------------------------
array( "c" => "文章分类2",
"list" => array(
array("t" => "文章标题1"),
array("t" => "文章标题2"),
array("t" => "文章标题3"),
array("t" => "文章标题4"),
array("t" => "文章标题5")
)
),
//------------------------
array("c" => "文章分类3",
"list" => array(
array("t" => "文章标题1"),
array("t" => "文章标题2"),
array("t" => "文章标题3"),
array("t" => "文章标题4"),
array("t" => "文章标题5")
)
)
//------------------------
);
$cat = array(
// --------------------
array( "c" => "文章分类1",
"list" => array(
array("t" => "文章标题1"),
array("t" => "文章标题2"),
array("t" => "文章标题3"),
array("t" => "文章标题4"),
array("t" => "文章标题5")
)
),
// ---------------------------
array( "c" => "文章分类2",
"list" => array(
array("t" => "文章标题1"),
array("t" => "文章标题2"),
array("t" => "文章标题3"),
array("t" => "文章标题4"),
array("t" => "文章标题5")
)
),
//------------------------
array("c" => "文章分类3",
"list" => array(
array("t" => "文章标题1"),
array("t" => "文章标题2"),
array("t" => "文章标题3"),
array("t" => "文章标题4"),
array("t" => "文章标题5")
)
)
//------------------------
);
$R = mysql_query("SELECT 分类ID,名称 FROM 分类表");
while($RE = mysql_fetch_array($R))
{
$cat[$COUNT]['c'] = $RE['名称'];
$r = mysql_query("SELECT 标题 FROM 标题表 WHERE 分类ID=".$RE['分类ID']);
$count = 0;
while($re = mysql_fetch_array($r))
{
$cat[$COUNT]['list'][$count++]['t'] = $re['标题'];
}
$COUNT++;
}