ryuozero Site Admin
�������: 13 Jul 2005 �ͺ: 1145
|
�ͺ�����: Sun Mar 13, 2011 12:33 pm ����ͧ: scrip �Ǣ����Ũҡ���ҧ��� |
|
|
<?php
include "../conect_in.php";
$result = mysql_query("SELECT * FROM data_com");
?>
<table width="97%" border="1" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr bgcolor="#FFFFCC">
<td><div align="center">�Ţ������ͧ</div></td>
<td><div align="center">�ѹ����Ѻ</div></td>
<td><div align="center">�ҡ</div></td>
<td><div align="center">����ͧ</div></td>
<td><div align="center">˹��§ҹ</div></td>
<td><div align="center">ʶҹ�</div></td>
</tr>
<?
while($row = mysql_fetch_array($result))
{
$re_g = $row[id_group];
$group = mysql_query("SELECT * FROM data_group where id_group = $re_g");
$groupID = mysql_fetch_array($group);
$re_st = $row[ID_ST];
$statust = mysql_query("SELECT * FROM data_statust where ID_ST = $re_st");
$statustID = mysql_fetch_array($statust);
?>
<tr>
<td><div align="center"><? echo $row['ID_IN'] ?></div></td>
<td><div align="center"><? echo $row['DATE'] ?></div></td>
<td><div align="center"><? echo $row['ID_FROM'] ?></div></td>
<td><div align="center"><? echo $row['ID_STORY'] ?></div></td>
<td><div align="center"><? echo $groupID['group_description'] ?></div></td>
<td><div align="center"><? echo $statustID['detail_ST'] ?></div></td>
</tr>
<? } ?>
</table>
<?
mysql_close($con);
?> |
|