GUEST BOOK

"January", "02" => "February", "03" => "March", "04" => "April", "05" => "May", "06" => "June", "07" => "July", "08" => "August", "09" => "September", "10" => "October", "11" => "November", "12" => "December" ); $aryMntTh = array( "01" => "มกราคม", "02" => "กุมภาพันธ์", "03" => "มีนาคม", "04" => "เมษายน", "05" => "พฤษภาคม", "06" => "มิถุนายน", "07" => "กรกฏาคม", "08" => "สิงหาคม", "09" => "กันยายน", "10" => "ตุลาคม", "11" => "พฤศจิกายน", "12" => "ธันวาคม" ); $host="localhost";$user="dummy";$password="dmpass"; mysql_connect($host,$user,$password); $result = mysql_db_query("guestbook","select * from guests"); $num = mysql_num_rows($result); echo "มีผู้เซ็นต์เยี่ยมแล้วทั้งหมดจำนวน $num ท่าน :

"; $num = $num-1; echo "\n\n"; $i=0; while ($i=$num) { echo "\n\n\n"; echo "\n"; echo ""; echo "\n

"; echo mysql_result($result,$num,"fname"); echo " "; echo mysql_result($result,$num,"lname"); echo "
E-Mail:	"; echo ""; echo mysql_result($result,$num,"email"); echo "
address:	"; echo mysql_result($result,$num,"address"); echo "

\n"; echo "  Comments : "; $comment=mysql_result($result,$num,"Comment"); echo $comment; echo "\n\n\n"; echo "\n\n"; $xdate=mysql_result($result,$num,"xdate"); $yy=substr($xdate,0,4); $mm=substr($xdate,5,2); $dd=substr($xdate,8,2); $dt=substr($xdate,10,12); //echo "
Date : "; echo $dd; echo " "; echo $aryMntEng[$mm]; //echo " "; echo $yy; echo "
  วันที่ "; echo $dd; echo " "; echo $aryMntTh[$mm]; echo " พ.ศ. "; echo $yy+543; echo "  เวลา "; echo $dt; echo "