session_start(); include "./conf/dbinfo.php"; // DB Á¤º¸ include "./lib/php/lib.php"; // ¶óÀ̺귯¸®(ÇÔ¼ö) include "./lib/php/register_globals_on.php"; // Register Globals $conn = my_connect($dbhost, $dbid, $dbpass, $dbname); $parameter = "&sopt=$sopt&stitle=$stitle&page=$page"; $page_scale = 15; $code = "profile"; // °Ë»ö if($stitle) { if($sopt == "all") { $where = " AND ( subject LIKE '%$stitle%' OR author LIKE '%$stitle%' OR content LIKE '%$stitle%' ) "; } else { $where = " AND $sopt LIKE '%$stitle%'"; } } $sql = "SELECT * FROM $code WHERE approval = 'Y' $where ORDER BY num DESC"; $rs = mysql_query($sql); $total_bnum = mysql_num_rows($rs); ?>
|