include_once("lib/db_setup.php");
include_once("lib/functions.php");
mysql_connect($mysqlServer, $mysqlUserName, $mysqlPassword);
mysql_select_db ($mysqlDatabase);
$page = $_SERVER["REQUEST_URI"];
$page = preg_replace("[.php$]", '', $page);
$page = preg_replace("[.html$]", '', $page);
list($cate_name, $c_code, $sc_code) =split("-", $page, 3);
$sql_cat = "select name, name2 from category where code='$c_code'";
$result_cat = mysql_query($sql_cat);
$record_cat = mysql_fetch_array($result_cat);
$c_name = $record_cat[name];
$c_name2 = $record_cat[name2];
$sc_name = '';
$sql_c = "select * from category_sample where c_code='$c_code' and sc_code='' order by item";
$subcat='';
if($sc_code != '00'){
$sql_c = "select * from category_sample where c_code='$c_code' and sc_code='$sc_code' order by item";
$sql_scat = "select name, name2 from subcategory where code='$sc_code' and category_code='$c_code'";
$result_scat = mysql_query($sql_scat);
$record_scat = mysql_fetch_array($result_scat);
$sc_name = $record_scat[name];
$sc_name2 = $record_scat[name2];
$subcat="Sub Category: $sc_name2";
}
$sql_c2 = $sql_c . ' limit 1';
$result_c2 = mysql_query($sql_c2);
$record_c2 = mysql_fetch_array($result_c2);
$keyword = $record_c2[keyword];
$desc = $record_c2[description];
$content = $record_c2[content];
$page_title= $record_c2[title];
include_once('inc/header_category.php');
include_once('inc/get_category_show_data.php');
print "Category: $c_name2
";
if($subcat !=''){
print $subcat;
}
$result_c = mysql_query($sql_c);
while ($record_c = mysql_fetch_array($result_c)){
include('inc/get_category_show_data2.php');
echo '
';
echo ' "; include("templates/$template"); echo ' |