|
|
$sql = "select * from tbl_topics order by t_no desc";
$sql = mb_convert_encoding("$sql","UTF8","SJIS");
$result = mysql_query($sql) or die ("SQL構文にエラーがあります。: $sql.". mysql_error());
$rows = mysql_numrows($result);
if($rows!=0){
for($i =0; $i < $rows;$i++){
$NO = mysql_result($result,$i,0);
$TITLE = mb_convert_encoding(mysql_result($result,$i,1),"SJIS","UTF8");
$DATE = mb_convert_encoding(mysql_result($result,$i,2),"SJIS","UTF8");
$URL = mb_convert_encoding(mysql_result($result,$i,3),"SJIS","UTF8");
$PDFNAME = "/home/sites/chicappa.jp/users/chicappa.jp-onsenkyo/web/pdf/".$NO.".pdf";
if(file_exists($PDFNAME)){
$URL = "/pdf/".$NO.".pdf";
}
if($URL == ""){
?>
echo $TITLE ?> echo $DATE ?> }else{ ?>echo $TITLE ?> echo $DATE ?> } } } ?> |
南あわじ市 あわじナビ!(淡路島観光協会) 兵庫・徳島「鳴門の渦潮」世界遺産登録推進協議会 |