|
|
|
|
|
//set value
$cid=$cid;
$table = 'topic';
$maxshow = 10 ;
$php_board = "page_b.php";
$php_boarddetail = "page_bx.php";
// user require
require("connect.php");
mysql_connect($host,$uid,$pw) or die ("Unalbe to connect to SQL server");
mysql_select_db($db) or die ("Unable to select database");
$sql_cid = "select * from menu where cid=$cid ";
$result_cid= mysql_query($sql_cid) or die ("Can't Perform Query1");
$row_cid=mysql_fetch_array($result_cid);
echo "$row_cid[$cid_txt]";
if (!isset($show)){
$show=0;
}
$sql = "select * from $table where cid=$cid order by cno ";
$result = mysql_query($sql) or die ("Can't Perform Query1");
if ($result)
{
$count = mysql_num_rows($result);
}
//connect database
$sql = "select * from $table where cid='$cid' order by cid ";
mysql_connect($host,$uid,$pw) or die ("Unalbe to connect to SQL server");
mysql_select_db($db) or die ("Unable to select database");
$result = mysql_query($sql) or die ("Can't Perform Query");
// show data loop
echo ("");
while($row=mysql_fetch_array($result)){
echo "";
if ($row[4]!=""){
echo " | ";
} else {
echo " | ";
}
echo " $row[$txt1] $row[$txt2]";
echo "
| ";
echo " | ";
}
echo " ";
?>
|
|
|
|
|
|
|
|