同人音楽.info レビュー http://www.dojin-music.info/ 同人音楽.infoのレビュー更新情報など ja "; $result = db_query("SELECT * FROM `dojin_review` LEFT JOIN `dojin_cd` ON `dojin_review`.`id` = `dojin_cd`.`cd_id` ORDER BY `date` DESC LIMIT 15"); $number = mysql_num_rows($result); for($i=0;$i<$number;$i++){ $review = mysql_fetch_assoc($result); print "\t\t\n"; } print " "; $result = db_query("SELECT * FROM `dojin_review` LEFT JOIN `dojin_cd` ON `dojin_review`.`id` = `dojin_cd`.`cd_id` ORDER BY `date` DESC LIMIT 15"); for($i=0;$i<$number;$i++){ $review = mysql_fetch_assoc($result); $year = substr($review[date],0,4); $month = substr($review[date], 4, 2); $day = substr($review[date], 6, 2); $hour = substr($review[date], 8, 2); $min = substr($review[date], 10, 2); $sec = substr($review[date], 12, 2); $desc = substr(strip_tags(mb_convert_encoding(str_replace(array("\r\n","\n","\r"), '', $review[text]),"UTF-8","UTF-8")),0,250); $result2 = db_query("SELECT * FROM `dojin_user` WHERE `id` = $review[user_id]"); $user = mysql_fetch_assoc($result2); $name_8 = $review[name]; $hname_8 = $user[hname]; print "\t \t\t{$name_8}のレビュー by {$hname_8} - 同人音楽.info \t\thttp://www.dojin-music.info/cd/{$review[id]}/review/ \t\t{$desc} \t\t$year-$month-{$day}T$hour:$min:$sec+09:00 \t\t{$hname_8} \t "; } print ""; exit; ?>