$SQL = mysql_query("select * from docboard_board where code=4 order by num desc limit 0,4");
$i=1;
while ($rs=mysql_fetch_array($SQL)) {
$subject_length=45;
if (strlen($rs[subject])>$subject_length)
{
$subject = substr($rs[subject],0,$subject_length);
preg_match('/^([\x00-\x7e]|.{2})*/', $subject, $subject);
$subject = $subject[0] . "..";
}
else
{
$subject = $rs[subject];
}
$reg_date = $rs[writeday];
$reg_date = date('Ymd',strtotime($reg_date));
$mkt = mktime()-604800; // 7ÀÏÀüÀdz¯Â¥¸¦ ±¸ÇÑ´Ù. 86400*2
$compare_day= date('Ymd', $mkt);
//echo $compare_day . "-" . $reg_date;
if($compare_day <= $reg_date)
{
$subject .= " ";
}
?>
 |
=$subject?> |
|=substr($rs[writeday],0,10)?> |
4) {?>
 |
}?>
$i++;
}
?>
|
|
|
 |
$SQL = mysql_query("select * from docboard_board where code=2 or code=6 or code=9 order by num desc limit 0,4");
$i=1;
while ($rs=mysql_fetch_array($SQL)) {
$subject_length=40;
if (strlen($rs[subject])>$subject_length) {
$subject = substr($rs[subject],0,$subject_length);
preg_match('/^([\x00-\x7e]|.{2})*/', $subject, $subject);
$subject = $subject[0] . "..";
} else {
$subject = $rs[subject];
}
if ($rs[code]==2) {
$dir="data";
$s="ȍ";
} else if ($rs[code]==6) {
$dir="board";
$s="°¡";
} else if ($rs[code]==9) {
$dir="divide";
$s="¼º";
}
$reg_date = $rs[writeday];
$reg_date = date('Ymd',strtotime($reg_date));
$mkt = mktime()-604800; // 7ÀÏÀüÀdz¯Â¥¸¦ ±¸ÇÑ´Ù. 86400*2
$compare_day= date('Ymd', $mkt);
//echo $compare_day . "-" . $reg_date;
if($compare_day <= $reg_date)
{
$subject .= " ";
}
?>
 |
=$s?>)=$subject?> |
} else {?>
=$s?>)=$subject?> |
}?>
|=substr($rs[writeday],0,10)?> |
4) {?>
 |
}?>
$i++;
}
?>
|
|
|
|
|
|
|
¿À´ÃÀÇ ¸»¾¸ : |
$SQL1 = mysql_query("select max(num) from auction_table");
$rs1 = mysql_fetch_array($SQL1);
$SQL = mysql_query("select * from auction_table where num=$rs1[0]");
$rs = mysql_fetch_array($SQL);
?>
| |
|
|
|
|
|
|
|
|
 |
|
|
 |
|
|
 |
|