<form method="GET;" action="option.php">
<?
$db="information";
$host="localhost";
$uname="root";
$passwd="";
$tb="timmer";
$connect= mysql_connect( $host,$uname,$passwd) or die ("µÔ´µè͡Ѻ°Ò¹¢éÍÁÙÅ Mysql äÁèä´é ");
mysql_select_db($db) or die("àÅ×Í¡°Ò¹¢éÍÁÙÅäÁèä´é");
$sql = "SELECT * FROM $tb order by timmer.time_id";
SELECT ass_TMAJORINDEPT.PROGRAMCODE, ass_TPROGRAM.NAMET FROM ass_TPROGRAM INNER JOIN ass_TMAJORINDEPT ON
ass_TPROGRAM.PROGRAMCODE = ass_TMAJORINDEPT.PROGRAMCODE group by ass_TMAJORINDEPT.PROGRAMCODE,
ass_TPROGRAM.NAMET</center><option>-------------- ¡ÃسÒàÅ×Í¡ÇѹàÇÅÒÊͺ ----------------</option>
<?
mysql_connect( $host,$uname,$passwd) or die ("µÔ´µè͡Ѻ°Ò¹¢éÍÁÙÅ Mysql äÁèä´é ");
mysql_select_db($db) or die("àÅ×Í¡°Ò¹¢éÍÁÙÅäÁèä´é"); /* ·Ó¡ÒÃàÅ×Í¡°Ò¹¢éÍÁÙÅ¡è͹ */
$sql = 'SELECT subject.sub_id, subject.sub_name, timmer.date, timmer.time'
. ' FROM subject'
. ' INNER JOIN ( timmer'
. ' INNER JOIN regtime ON timmer.time_id = regtime.time_id ) ON subject.sub_id = regtime.sub_id where time_id = "'. $date1 . '"';
<form method="$_GET[date1];" action="option.php">
<?
$db="information";
$host="localhost";
$uname="root";
$passwd="";
$tb="timmer";
$connect= mysql_connect( $host,$uname,$passwd) or die ("µÔ´µè͡Ѻ°Ò¹¢éÍÁÙÅ Mysql äÁèä´é ");
mysql_select_db($db) or die("àÅ×Í¡°Ò¹¢éÍÁÙÅäÁèä´é");
$sql = "SELECT * FROM $tb order by timmer.time_id";
SELECT ass_TMAJORINDEPT.PROGRAMCODE, ass_TPROGRAM.NAMET FROM ass_TPROGRAM INNER JOIN
ass_TMAJORINDEPT ON
ass_TPROGRAM.PROGRAMCODE = ass_TMAJORINDEPT.PROGRAMCODE group by ass_TMAJORINDEPT.PROGRAMCODE,
ass_TPROGRAM.NAMET</center><option>-------------- กรุณาเลือก----------------</option>
<?
mysql_connect( $host,$uname,$passwd) or die ("µÔ´µè͡Ѻ°Ò¹¢éÍÁÙÅ Mysql äÁèä´é ");
mysql_select_db($db) or die("àÅ×Í¡°Ò¹¢éÍÁÙÅäÁèä´é"); /* ·Ó¡ÒÃàÅ×Í¡°Ò¹¢éÍÁÙÅ¡è͹ */
$sql = 'SELECT subject.sub_id, subject.sub_name, timmer.date, timmer.time'
. ' FROM subject'
. ' INNER JOIN ( timmer'
. ' INNER JOIN regtime ON timmer.time_id = regtime.time_id ) ON subject.sub_id = regtime.sub_id where time_id = "'. $date1 . '"';