if ( mysql_affected_rows() == 0 ) {
if (mysql_affected_rows() == 0 && mysql_matched_row() == 0){
concat_ws(',','$html', '$wr_secret', '$mail')
mysql_num_rows
if (mysql_affected_rows() == 0 && mysql_matched_row() == 0){
concat_ws(',','$html', '$wr_secret', '$mail')
mysql_num_rows
$sql = " select a.*, b.mb_nick, count(*) as cnt, sum(a.wr_1) as point_sum
from $g4[write_prefix]$bo_id a left join g4_member b on a.wr_3 = b.mb_id
where a.wr_is_comment = 0 and trim(a.wr_3) <> '' and wr_datetime between '$date_gap' and '$g4[time_ymd]'
group by a.wr_3
order by cnt desc, point_sum desc
limit 0, $pop_cnt ";
from $g4[write_prefix]$bo_id a left join g4_member b on a.wr_3 = b.mb_id
where a.wr_is_comment = 0 and trim(a.wr_3) <> '' and wr_datetime between '$date_gap' and '$g4[time_ymd]'
group by a.wr_3
order by cnt desc, point_sum desc
limit 0, $pop_cnt ";
$point_num = number_format($_f_obj->mb_point_yc4);
alert("전환할 적립포인트가 부족합니다. 최대전환 가능포인트는 {$point_num}포인트 입니다.");
alert("전환할 적립포인트가 부족합니다. 최대전환 가능포인트는 {$point_num}포인트 입니다.");
mysql_insert_id() : 마지막 삽입한 auto increment record의 id
$sql = " select
n1.bo_table, n1.wr_parent
from
(select *
from $g4[board_new_table] where mb_id <> '$member[mb_id]'
and datediff(curdate(), bn_datetime) <= $my_date
and wr_parent <> wr_id
) as n1,
(select wr_id, bn_datetime
from $g4[board_new_table]
where wr_id = wr_parent
and mb_id='$member[mb_id]'
) as n2
where
n1.wr_parent = n2.wr_id
group by n1.bo_table, n1.wr_parent
order by n1.bn_datetime desc ";
n1.bo_table, n1.wr_parent
from
(select *
from $g4[board_new_table] where mb_id <> '$member[mb_id]'
and datediff(curdate(), bn_datetime) <= $my_date
and wr_parent <> wr_id
) as n1,
(select wr_id, bn_datetime
from $g4[board_new_table]
where wr_id = wr_parent
and mb_id='$member[mb_id]'
) as n2
where
n1.wr_parent = n2.wr_id
group by n1.bo_table, n1.wr_parent
order by n1.bn_datetime desc ";
$_SERVER[PHP_SELF]?$qstr&page=
alert("목록을 볼 권한이 없습니다.\\n\\n회원이시라면 로그인 후 이용해 보십시오.", "./login.php?wr_id=$wr_id{$qstr}&url=".urlencode("board.php?bo_table=$bo_table&wr_id=$wr_id"));
var_dump($var)
var_dump($var)
- opencode.co.kr -