<?$objConnect = mysql_connect("localhost","siamboss_t1","1900") or die("Error Connect to Database");$objDB = mysql_select_db("siamboss_t1");mysql_query("SET character_set_results=utf8"); mysql_query("SET character_set_client=utf8"); mysql_query("SET character_set_connection=utf8"); ?>
<?include("connect.php");?> <?$strSQL = "SELECT * FROM phpbb_topics WHERE topic_approved = 1 AND topic_moved_id = 0 ORDER BY topic_time DESC limit 0,10";$objQuery = mysql_query($strSQL) or die ("Error Query <".$strSQL.">");?><?$i=0;while($objResult = mysql_fetch_array($objQuery)){$i++;if($i%2==0){$bg = "#43a6df";}else{$bg = "#f4f4f4";}{ $topic_title = $objResult<"topic_title">;}?> <? echo "$topic_title";?> <?}?> <?mysql_close($objConnect);?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><?php require("SSI.php"); ?><html><head><meta http-equiv="Content-Language" content="th"><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta http-equiv="refresh" content="900" ><title>วิธีดึง10 กระทู้ล่าสุดแบบ ssi_recentTopics | welovethailand.com</title> <base target="_blank"><style type="text/css">body,td,th { font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #0066FF;}a {font-size: 12px;color: #E79A0C;}a:link { color: navy; text-decoration: none}a:visited { color: #0000FF; text-decoration: none}a:active { color: #FF9900; text-decoration: underline}a:hover { color: Orange; text-decoration: underline}</style></head><body ><!--ดึง recentTopics--><?php ssi_recentTopics($num_recent =10 , $exclude_boards = null, $include_boards = 1, $output_method = 'echo'); ?><!--หมายเลข 10 คือจำนวนที่จะเเสดง / เลข 1 คือ id ของบอร์ดหรือโซนที่จะเเสดง ใส่ null ถ้าต้องการแสดงทุกบอร์ด--></body></html>
// Find all the posts in distinct topics. Newer ones will have higher IDs. $request = db_query(" SELECT m.posterTime, ms.subject, m.ID_TOPIC, m.ID_MEMBER, m.ID_MSG, b.ID_BOARD, b.name AS bName,
// Find all the posts in distinct topics. Newer ones will have higher IDs. $request = db_query(" SELECT t.numViews, t.numReplies,m.posterTime, ms.subject, m.ID_TOPIC, m.ID_MEMBER, m.ID_MSG, b.ID_BOARD, b.name AS bName,
// Build the array. $posts[> = array( 'board' => array( 'id' => $row['ID_BOARD'>, 'name' => $row['bName'>, 'href' => $scripturl . '?board=' . $row['ID_BOARD'> . '.0', 'link' => '<a href="' . $scripturl . '?board=' . $row['ID_BOARD'> . '.0">' . $row['bName'> . '</a>' ), 'topic' => $row['ID_TOPIC'>,
'views' => $row['numViews'>, 'replies' => $row['numReplies'>,
<?php ssi_recentTopics($num_recent = 8, $exclude_boards = null, $include_boards = 1, $output_method = 'echo'); ?>
โปรดรอ
cymiz.com insurance