 |
ช่วยด้วยค่ะจะต้องแก้ไขตรงไหนบ้างค่ะ <meta http-equiv="Content-Type" content="text/h |
| |
 |
|
|
 |
 |
|
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<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";
$db_query=mysql_db_query($db,$sql);
$num_rows=mysql_num_rows($db_query); /* ¹Ñº Reccord ·Õ辺 */
?>
<select name="$date1">
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>
<?
$a=0;
while($a < $num_rows)
{
$result = mysql_fetch_array($db_query);
$time_id=$result[time_id];
$date=$result[date];
$time=$result[time];
?>
<option value="<?echo"$time_id";?>">Çѹ·Õè <?echo"$date";?> àÇÅÒ <?echo"$time";?></option>
<?
$a++;
}
?>
</select>
</form>
<font face="Microsoft Sans Serif" size="2" color="#800080">
<?
$date1 = $_GET["date1"];
echo"$date1";
if (empty($date1))
{
echo"¡ÃسÒàÅ×Í¡ÃÒ¡Òäé¹ËÒ ´éǤÃѺ";
exit();
}
else
{
$db="information";
$host="localhost";
$uname="root";
$passwd="";
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 . '"';
$db_query=mysql_db_query($db,$sql);
$num_rows=mysql_num_rows($db_query); /* ¹Ñº Reccord ·Õ辺 */
echo"$sql";
if(empty($num_rows)) /* µÃǨÊͺÇèÒÁÕÍÂÙèËÃ×ÍÂѧ */
{
echo"<center><br>äÁ辺¢éÍÁÙÅ <b>$keyword</b> ¨Ò¡ Filed <b>$fields <b> </center>";
exit();
}
else
{
?>
<div align="center"><? echo "<h2>µÒÃÒ§Êͺ»ÃШӻաÒÃÈÖ¡ÉÒ <b>1/2549</b></h2><br>áÊ´§ÃÒ¡Òäé¹ËÒ <b>$keyword</b> ¾º·Ñé§ËÁ´ <b>$num_rows</b> ÃÒ¡Òà ";
?><br><br>
</div>
<table border="1" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="599">
<tr>
<td width="8%" style="border-style: solid; border-width: 1" align="center"><font face="Microsoft Sans Serif" size="2" color="#800080"><b>ÃËÑÊÇÔªÒ</td>
</tr>
</table>
<?
$a=0;
while($a < $num_rows)
{
$result = mysql_fetch_array($db_query);
$time_id=$result[time_id];
$date=$result[date];
$time=$result[time];
?>
<table border="1" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="599">
<tr>
<td width="8%" style="border-style: solid; border-width: 1" align="center"><font face="Microsoft Sans Serif" size="2" color="#800080"><?echo"$date";?></td>
</tr>
</table>
<?
$a++;
}
}
}
?>
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
13 ก.ย. 2549 13:42:59 |
By :
หนิง |
View :
2183 |
Reply :
3 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
ตัวหนังสืออ่านไม่ได้อะ 
|
| |
|
|
| |
| Date :
13 ก.ย. 2549 14:04:16 |
By :
InwCluB |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<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";
$db_query=mysql_db_query($db,$sql);
$num_rows=mysql_num_rows($db_query); /* ¹Ñº Reccord ·Õ辺 */
?>
<select name="$date1" onChange="javascript:form.submit();">
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>
<?
$a=0;
while($a < $num_rows)
{
$result = mysql_fetch_array($db_query);
$time_id=$result[time_id];
$date=$result[date];
$time=$result[time];
?>
<option value="<?echo"$time_id";?>">วันที่<?echo"$date";?> เวลา <?echo"$time";?></option>
<?
$a++;
}
?>
</select>
</form>
<font face="Microsoft Sans Serif" size="2" color="#800080">
<?
$date1 = $_GET["date1"];
echo"$date1";
if (empty($date1))
{
echo"¡ÃسÒàÅ×Í¡ÃÒ¡Òäé¹ËÒ ´éǤÃѺ";
exit();
}
else
{
$db="information";
$host="localhost";
$uname="root";
$passwd="";
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 . '"';
$db_query=mysql_db_query($db,$sql);
$num_rows=mysql_num_rows($db_query); /* ¹Ñº Reccord ·Õ辺 */
echo"$sql";
if(empty($num_rows)) /* µÃǨÊͺÇèÒÁÕÍÂÙèËÃ×ÍÂѧ */
{
echo"<center><br>äÁ辺¢éÍÁÙÅ <b>$keyword</b> ¨Ò¡ Filed <b>$fields <b> </center>";
exit();
}
else
{
?>
<div align="center"><? echo "<h2>µÒÃÒ§Êͺ»ÃШӻաÒÃÈÖ¡ÉÒ <b>1/2549</b></h2><br>áÊ´§ÃÒ¡Òäé¹ËÒ <b>$keyword</b> ¾º·Ñé§ËÁ´
<b>$num_rows</b> ÃÒ¡Òà ";
?><br><br>
</div>
<table border="1" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="599">
<tr>
<td width="8%" style="border-style: solid; border-width: 1" align="center"><font face="Microsoft Sans Serif" size="2"
color="#800080"><b>ÃËÑÊÇÔªÒ</td>
</tr>
</table>
<?
$a=0;
while($a < $num_rows)
{
$result = mysql_fetch_array($db_query);
$time_id=$result[time_id];
$date=$result[date];
$time=$result[time];
?>
<table border="1" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="599">
<tr>
<td width="8%" style="border-style: solid; border-width: 1" align="center"><font face="Microsoft Sans Serif" size="2"
color="#800080"><?echo"$date";?></td>
</tr>
</table>
<?
$a++;
}
}
}
?>
บริเวรไม่มีอะไร
|
| |
|
|
| |
| Date :
13 ก.ย. 2549 22:16:09 |
By :
หนิง |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ติดตรงไหนบอกด้วยค่ะ ขี้เกียจอ่าน!!!
|
| |
|
|
| |
| Date :
14 ก.ย. 2549 10:35:41 |
By :
ไม่ลองไม่รู้ |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
