while($row=mysql_fetch_array($result)){ $slID = $row["id"]; $slPic = $row["pic"]; $sltitle = $row["title"]; $sldetail = $row["detail"]; //<!-- Slide --> echo "<div id='s3slider'>"; echo "<ul id='s3sliderContent'>"; //<!-- Slide 1 begin --> echo "<li class='s3sliderImage'> <img src='Slide/".$slPic."' width='650' height='400'> <span class='top'>$sldetail</span> </li>"; //<!-- Slide 1 end --> // <!-- Slide 2 begin --> echo "<li class='s3sliderImage'>"; echo "<li class='s3sliderImage'> <img src='Slide/".$slPic."' width='650' height='400'> <span class='top'>$sldetail</span> </li>"; //<!--- end --> echo "<div class='clear s3sliderImage'></div>"; echo "</ul>"; echo "</div>"; }
$result = " ........SQL ........ ORDER BY rand() LIMIT 5";
<? $DBServer = "localhost"; $DBName = "edu_clinic"; $DBUsername = "root"; $DBPassword = "1234"; $conn = mysql_connect($DBServer, $DBUsername , $DBPassword ) or die("Could not connect to dbserver"); mysql_select_db($DBName,$conn); mysql_query("SET NAMES UTF8"); $sql = "SELECT * FROM `m_slide` order by rand() limit 5"; $result = mysql_query($sql); echo"<table border='0' width='100%'>"; $row=mysql_fetch_array($result); $slID = $row["id"]; $slPic = $row["pic"]; $sltitle = $row["title"]; $sldetail = $row["detail"]; //<!-- Slide --> echo "<div id='s3slider'>"; echo "<ul id='s3sliderContent'>"; //<!-- Slide 1 begin --> echo "<li class='s3sliderImage'> <img src='Slide/".$slPic."' width='650' height='400'> <span class='top'>$sldetail</span> </li>"; //<!-- Slide 1 end --> // <!-- Slide 2 begin --> // echo "<li class='s3sliderImage'>"; //echo "<li class='s3sliderImage'> <img src='Slide/".$slPic."' width='650' height='400'> <span class='top'>$sldetail</span> </li>"; //<!--- end --> echo "<div class='clear s3sliderImage'></div>"; echo "</ul>"; echo "</div>"; echo "</table>"; ?>
$sql = "SELECT * FROM m_slide ORDER BY rand() LIMIT 1";
echo "<li class='s3sliderImage'> <img src='Slide/".$slPic."' width='650' height='400'> <span class='top'>$sldetail</span> </li>";
<?PHP $DBServer = "localhost"; $DBName = "edu_clinic"; $DBUsername = "root"; $DBPassword = "1234"; $conn = mysql_connect($DBServer, $DBUsername , $DBPassword ) or die("Could not connect to dbserver"); mysql_select_db($DBName,$conn); mysql_query("SET NAMES UTF8"); echo"<table border='0' width='100%'>"; //<!-- Slide --> echo "<div id='s3slider'>"; echo "<ul id='s3sliderContent'>"; $sql = "SELECT * FROM m_slide ORDER BY rand() LIMIT 5"; $result = mysql_query($sql); while($row=mysql_fetch_array($result)){ $slID = $row["id"]; $slPic = $row["pic"]; $sltitle = $row["title"]; $sldetail = $row["detail"]; //<!-- Slide 1 begin --> echo "<li class='s3sliderImage'> <img src='Slide/".$slPic."' width='650' height='400'> <span class='top'>$sldetail</span> </li>"; //<!-- Slide 1 end --> } // <!-- Slide 2 begin --> // echo "<li class='s3sliderImage'>"; //echo "<li class='s3sliderImage'> <img src='Slide/".$slPic."' width='650' height='400'> <span class='top'>$sldetail</span> </li>"; //<!--- end --> echo "<div class='clear s3sliderImage'></div>"; echo "</ul>"; echo "</div>"; echo "</table>"; ?>
$sql = "SELECT * FROM `m_slide ` ORDER BY `m_slide `.`id` DESC ";
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง