โดย sutawee » 19/01/2013 9:14 pm
โค้ด: เลือกทั้งหมด
<?
$link = mysql_connect("localhost","root","1234");
mysql_query("Use guest;");
mysql_query("set NAMES tis620");
$sql ="Select * From guestdata Order By date Desc;";
$result =mysql_query($sql);
while ($dbarr = mysql_fetch_array($result))
{
echo "<Table Border=1>";
echo "<Tr>";
echo "<Td><b>:</b>ชื่อ-สกุล</Td>";
echo "<Td>$dbarr[name]</Td>";
echo "</Tr>";
echo "<Tr>";
echo "<Td><b> E-Mail Address: </b></Td>";
echo "<Td><a href=mailto:$dbarr[email]>$dbarr[email]</Td>";
echo "</Tr>";
echo "<Tr>";
echo "<Td><b>คำแนะนำ ติชม</b><Td>";
echo "<Td>$dbarr[comment]</Td>";
echo "</Tr>";
echo "<Tr>";
echo "<Td><b>วันเวลาเข้ามาเยี่ยม</b></Td>";
echo "<Td><$dbarr[data]</Td>";
echo "</Tr>";
echo "<Tr>";
echo "<Td><b>IP Address: </b></Td>";
echo "<Td><$dbarr[ip] </Td>";
echo "</Tr>";
echo "</Table><P>";
}
mysql_close($link);
?>
[code=php]<?
$link = mysql_connect("localhost","root","1234");
mysql_query("Use guest;");
mysql_query("set NAMES tis620");
$sql ="Select * From guestdata Order By date Desc;";
$result =mysql_query($sql);
while ($dbarr = mysql_fetch_array($result))
{
echo "<Table Border=1>";
echo "<Tr>";
echo "<Td><b>:</b>ชื่อ-สกุล</Td>";
echo "<Td>$dbarr[name]</Td>";
echo "</Tr>";
echo "<Tr>";
echo "<Td><b> E-Mail Address: </b></Td>";
echo "<Td><a href=mailto:$dbarr[email]>$dbarr[email]</Td>";
echo "</Tr>";
echo "<Tr>";
echo "<Td><b>คำแนะนำ ติชม</b><Td>";
echo "<Td>$dbarr[comment]</Td>";
echo "</Tr>";
echo "<Tr>";
echo "<Td><b>วันเวลาเข้ามาเยี่ยม</b></Td>";
echo "<Td><$dbarr[data]</Td>";
echo "</Tr>";
echo "<Tr>";
echo "<Td><b>IP Address: </b></Td>";
echo "<Td><$dbarr[ip] </Td>";
echo "</Tr>";
echo "</Table><P>";
}
mysql_close($link);
?>[/code]