require('include/conn.php');
require('include/function.php');
$ldid = fixsql("mgid",0);
$sql = "select L.title,L.des as l_des,L.real_name as l_real_name,L.email,L.secret_flag,L.udate as l_udate,R.re_leaveword_id,R.real_name as r_real_name,R.des as r_des,R.udate as r_udate from leaveword as L left join re_leaveword as R on L.leaveword_id=R.leaveword_id where L.leaveword_id=$ldid";
//echo $sql;
mysql_query("set NAMES 'UTF8'");
$rs = mysql_query($sql,$link) or die("db query false");
$line = mysql_fetch_array($rs,MYSQL_ASSOC);
if(isset($line)){
$leaveword_title = $line["title"];
$leaveword_des = $line["l_des"];
$leaveword_des = nl2br($leaveword_des);
$leaveword_real_name = $line["l_real_name"];
$leaveword_email = $line["email"];
$secret_flag = $line["secret_flag"];
$leaveword_udate = $line["l_udate"];
$leaveword_udate = str_replace("-","/",$leaveword_udate);
$rlid = $line["re_leaveword_id"];
$re_real_name = $line["r_real_name"];
$re_des = nl2br($line["r_des"]);
$re_udate = $line["r_udate"];
$re_udate = str_replace("-","/",$re_udate);
if($secret_flag==1){
$leaveword_title = "悄悄話";
//$re_des = "悄悄話";
$leaveword_des = "悄悄話";
}
}
mysql_free_result($rs);
$sql = "update leaveword set brows=brows+1 where leaveword_id=$ldid";
mysql_query($sql,$link) or die("db query false");
?>
°☆∴primo極緻酒店∴☆°
|
|
|
|
|
|
 |
|
}else{?>
}?>
|
|
 |
|
|
|