|
//database connect , include file db_con.php3
include("../inc/db_con.php");
include("../inc/inc_fuc.php");
//show the detail record
if ($total==0 and isset($total)){
//sql
$sql = "select * from t_km_c where 1=1 and enable='1'";
if (isset($id)){
$sql = $sql." and id=".$id;
}
//sql exec
$query=@mysql_query($sql,$connect);
$i=0;
//data not found
if (!$query)
{
echo "Data get Error(c1001). ";
echo $sql;
echo " ";
}
else
{
// read recorders
//rows
if ($array=mysql_fetch_array($query)){
echo " ".stripslashes($array[title])."";
echo " [ ".$array[create_date]." ]
";
echo "
| ".stripslashes($array[content])." | ";
echo " ";
//show all data
echo " 更多知识 ... ";
}else{
echo "No data found you want";
}
}
}elseif ($total=1 or !isset($total)){
//sql made
$sql = "select * from t_km_c ";
$sql = $sql."where 1 ";
$sql = $sql." and enable = 1 ";
$sql = $sql." order by create_date desc";
//sql exec
$query=@mysql_query($sql,$connect);
//data not found
if (!$query)
{
echo "Data get Error. ";
}else{
// read recorders
//rows
$i=0;
while ($array=@mysql_fetch_array($query))
{
echo " ".stripslashes($array[title])."";
echo " [ ".$array[create_date]." - ".convert_category("km_category","zhs",$array[km_category]).".".convert_category("km_subcategory","zhs",$array[km_subcategory])." ]";
echo "
";
// echo substr(stripslashes($array[content_jp]),0,200)."...";
$i++;
}
if ($i==0){
echo " No data found";
}
}
}
?>
|
|