web memo

ｺﾝﾃｽﾄチェック
SELECT
a.usercode,
a.username,
sum(b.pointnum) as pointnum
FROM
m_user  as a,
d_point as b,
m_contest as c
WHERE
a.usercode=b.usercode AND
b.contnmbr=c.contnmbr AND
c.contnmbr=6
GROUP BY
a.usercode,
a.username
ORDER BY
pointnum desc

###########################################################
# 参加コンテスト表示
###########################################################

#１フィールドで返す

Function fncGetDayContest($usercode,$contnmbr=””,$day=””) {
$sql = “SELECT *”
. ” FROM d_point”
. ” WHERE usercode = “.$usercode
. ” AND contnmbr = “.$contnmbr
. ” AND pintdate = ‘”. $day .”‘”;
$result = fncDbExec($sql);
$rows   = mysql_num_rows($result);
if ($rows == 1) {
$ret = mysql_fetch_array($result,MYSQL_ASSOC);
return($ret);
} else {
return(FALSE);
}
}

###########################################################
# 参加コンテスト表示
###########################################################

#配列で返す

Function fncGetContest($usercode,$type=1,$contnmbr=””) {
$sql = ‘SELECT’
. ‘ a.contname,’
. ‘ a.contnmbr,’
. ‘ sum(b.pointnum) as pointnum,’
. ‘ pinttani’
. ‘ FROM’
. ‘ m_contest as a,’
. ‘ d_point as b’
. ‘ WHERE’
. ‘ a.contnmbr=b.contnmbr AND’
. ” a.contcode=’”. $type .”‘ AND”
. ” b.usercode=’”. $usercode .”‘”;

if($contnmbr) $sql .= ” AND b.contnmbr=’”. $contnmbr .”‘”;

$sql .= ‘ GROUP BY’
. ‘ a.contname’
. ‘ ORDER BY’
. ‘ a.order_no’;
$result = fncDbExec($sql);
$rows   = mysql_num_rows($result);
if ($rows >= 1) {
while($row = mysql_fetch_array($result,MYSQL_ASSOC)){
$ret[] = $row;
}
return($ret);
} else {
return(FALSE);
}
}

SELECT
a.usercode,
a.username,
sum(b.pointnum) as pointnum
FROM
m_user  as a,
d_point as b,
m_contest as c
WHERE
a.usercode=b.usercode AND
b.contnmbr=c.contnmbr AND
c.contcode=1 AND
a.usercode=’103′
GROUP BY
a.usercode,
a.username
ORDER BY
pointnum desc

###########################################################
# (ポスカ、イケスタ等)のトータルランキング
###########################################################

SELECT
a.usercode,
a.username,
sum(b.pointnum) as pointnum
FROM
m_user  as a,
d_point as b,
m_contest as c
WHERE
a.usercode=b.usercode AND
b.contnmbr=c.contnmbr AND
c.contcode=1
GROUP BY
a.usercode,
a.username
ORDER BY
pointnum desc

SELECT
sum(pointnum)
FROM
d_point
WHERE
usercode=’101′ AND
contnmbr=1

SELECT
sum(pointnum) as pointnum
FROM
d_point as a,
m_contest as b
WHERE
a.contnmbr=b.contnmbr AND
b.contcode=1 AND
a.usercode=’101′

SELECT
a.contname,
sum(b.pointnum) as pointnum,
pinttani
FROM
m_contest as a,
d_point as b
WHERE
a.contnmbr=b.contnmbr AND
a.contcode=1 AND
b.usercode=’101′
GROUP BY
a.contname
ORDER BY
a.order_no

$sql = ‘SELECT’
. ‘ a.contname,’
. ‘ sum(b.pointnum) as pointnum,’
. ‘ pinttani’
. ‘ FROM’
. ‘ m_contest as a,’
. ‘ d_point as b’
. ‘ WHERE’
. ‘ a.contnmbr=b.contnmbr AND’
. ” a.contcode=’”. $type .”‘ AND”
. ” b.usercode=’”. $usercode .”‘”
. ‘ GROUP BY’
. ‘ a.contname’
. ‘ ORDER BY’
. ‘ a.order_no’;
$result = fncDbExec($sql);
while($row = mysql_fetch_array($result,MYSQL_ASSOC)){
$ret[] = $row;
}
return($ret);

$w_Time  = strtotime($datetime);    # 秒に変換
$w_day = date(“w”,$w_Time);        # 曜日

$w_ary1 = array(“日”,”月”,”火”,”水”,”木”,”金”,”土”);

$ret[0]  = date(“Y-m-d H:i:s”,$w_Time);                # 2006-01-01 12:00:00