<?
include("./config.php");
include("./function.php");
$subject=$_POST['subject'];
$text=$_POST['query_text'];
$faculty=$_POST['faculty'];
$login=$_POST['login'];
$student=get_studname($login);
$dt=$_POST['txtDate'];
mysql_query("insert into query (querysubject,querydate,querytext,staffid,studid, querystatus) values('$subject','$dt','$text','$faculty','$student','Unanswered')");
header("location: ./queries.php?msg=Query Added");
?>
<td width="20%" style="border-right:solid 1px #CC0000;"><div align="center">Student</div></td>
<td width="15%" style="border-right:solid 1px #CC0000;"><div align="center">Status</div></td>
<td width="10%" style="border-right:solid 1px #CC0000;"><div align="center">Detail</div></td>
<td width="10%" style="border-right:solid 1px #CC0000;"><div align="center">Edit</div></td>
<td width="10%"><div align="center">Delete</div></td>
</tr>
</table></td>
<td id="box_right"> </td>
</tr>
<tr>
<td colspan="3" width="899px" id="box_border" valign="top" align="center">
<div align="center">
<table border="0"id="border" width="100%">
<? ini_set('error_reporting', E_ALL ^ ~E_NOTICE ^ ~E_WARNING);
include("./config.php");
$result=mysql_query("select * from query where studid='".get_studname($_SESSION['cuser'])."' order by querydate desc");
while($row=mysql_fetch_array($result))
{
echo"<tr><td align='center' width='25%'><a href=./queries_detail.php?id=".$row['queryid'].">".substr($row['querysubject'],0,22)."...</a></td>
<td align=center width=10%>".$row['querydate']."</td>
<td align=center width=20%>".$row['studid']."</td>
<td align=center width=12%>".$row['querystatus']."</td>
<td align=center width=10%><a href=./queries_detail.php?id=".$row['queryid']."><img src=./images/detail_item.png alt=Detail border=0></a></td>
<td align=center width=10%><a href=./queries_edit.php?id=".$row['queryid']."><img src=./images/edit_item.png alt=Edit border=0></a></td>
<td align=center width=10%><a href=./queries_del.php?id=".$row['queryid']."><img src=./images/del_item.png alt=Delete border=0></a></td></tr>";
}
?>
</table>
</div> </td>
</tr>
