include "../italy/util.php";
session_start();
$cn = getConnect();
if($_GET['zz'] == "aaa"){
$sql = "SELECT
NAME,
MAIL,
PW,
FLOOR,
PROFILE,
RECOMMEND,
INFOR,
TWITTER,
HP,
MIXI,
FACEBOOK,
FBP,
TWITTERAPI ".
" FROM EXPO_ARTIST2013
WHERE ID = ".$_GET['id']." ORDER BY ID ";
}else{
$sql = "SELECT
NAME,
MAIL,
PW,
FLOOR,
PROFILE,
RECOMMEND,
INFOR,
TWITTER,
HP,
MIXI,
FACEBOOK,
FBP,
TWITTERAPI ".
" FROM EXPO_ARTIST2013
WHERE ID = ".$_GET['id']." and OPENFLG = '1' ORDER BY ID ";
}
if (!($rs = mysql_query($sql))) {
echo $sql;
die;
}
while ($item = mysql_fetch_array($rs)) {
$name = str_replace ("
","", "${item[0]}");
$mail = "${item[1]}";
$pw = "${item[2]}";
$floor = "${item[3]}";
$profile = "${item[4]}";
$recommend = "${item[5]}";
$infor = "${item[6]}";
$twitter = "${item[7]}";
$hp = "${item[8]}";
$mixi = "${item[9]}";
$facebook = "${item[10]}";
$fbp = "${item[11]}";
$twitterapi = "${item[12]}";
}
if($name != ""){
$sql = "SELECT
FILE, TYPE ".
" FROM EXPO_IMG2013
WHERE TYPE <> 9 and ARTIST_ID = ".$_GET['id'] ." order by ID desc";
if (!($rs = mysql_query($sql))) {
echo $sql;
die;
}
while ($item = mysql_fetch_array($rs)) {
$imgs[] = "${item[0]}";
$typs[] = "${item[1]}";
}
$sub = $_GET['id'];
$ua=$_SERVER['HTTP_USER_AGENT'];
if($_SESSION['aa'.$sub]=="") {
$sql = "INSERT INTO TBL_NEWS_COUNT (".
"NEWS_ID ,".
"IP,".
"TITLE,".
"UPDATE_DATE ,".
"REGIST_DATE ) ".
"VALUES".
"(".
"'".$sub."',".
"'".$_SERVER["REMOTE_ADDR"] ."',".
"'".$ua."',".
"now(),".
"now())";
if (!(mysql_query($sql))) {
echo $sql;
die;
}
}
}
$_SESSION['aa'.$sub]="aaaa";
mysql_close($cn);
?>
アーティスト名 | echo $name; ?> |
---|---|
ホームページ | echo $hp; ?> |
mixi | echo $mixi; ?> |
http://twitter.com/ echo $tws[$i]; ?> | |
http://twitter.com/ echo $tws; ?> | |
echo $elements[$i]; ?> | |
echo $elements; ?> |
} }else{ ?> @ echo $tw1; ?> からのツイート } } ?>