$host = "localhost";
$id = "root";
$pass = "diablo**77";
$dbname = "withpartnerxe";
$connect = mysql_connect($host,$id,$pass) or die("데이타베이스에 연결할 수 없습니다.");
mysql_select_db($dbname);
mysql_query("SET NAMES utf8");
$query = "select * from ad_d order by rand() limit 20";
$result = mysql_query($query, $connect);
while($data = mysql_fetch_array($result)){
$subject_color = $data['subject_color'] ? $data['subject_color'] : '#06f';
$bg_color = $data['bg_color'] ? $data['bg_color'] : '';
$memo_color = $data['memo_color'] ? $data['memo_color'] : '#666';
?>
- =$data['subject']?>
=$data['memo']?>
}
?>
mysql_close($connect);
?>