query checking....
Posted: Fri Aug 13, 2004 4:10 am
This is my query:
and this will execute from the query:
my question is what should I call (variable) for the "If statement" and where to put the "If statement" to make the second part doesn't execute if there is no result matched to the query.
I get confuse where to put the if, else and the {}
Code: Select all
<?php
session_start();
include("database.php");
$user=addslashes($_SESSION[username]);
$query="SELECT * FROM `leave` a INNER JOIN `employee` b ON b.`StaffNo` = a.`Super` WHERE b.`username` = '$user'AND a.`Status` = 'Pending Review'";
$result=mysql_query($query) or die(mysql_error());
$num=mysql_numrows($result);
?>Code: Select all
<?php
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<div align="left">
<table border="0" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<hr><b><i>STATUS PERMOHONAN CUTI</b></i><hr><br>
</td>
</tr>
</table>
</center></div>
<?
$i=0;
while ($i < $num)
{
$nama = mysql_result($result,$i,"Nama");
$jawatan = mysql_result($result,$i,"Jawatan");
$staffno = mysql_result($result,$i,"StaffNo");
$jenis = mysql_result($result,$i,"Jenis");
$mula = mysql_result($result,$i,"DateMula");
$tamat = mysql_result($result,$i,"DateTamat");
$mohon = mysql_result($result,$i,"DateMohon");
$refid = mysql_result($result,$i,"RefID");
$jumlah = mysql_result($result,$i,"Jumlah");
$status = mysql_result($result,$i,"Status");
$access = mysql_result($result,$i,"AccType");
$ack_by = mysql_result($result,$i,"EmpName");
?>
<div align="left">
<table border="0" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<b>Refference No:</b>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<strong><?echo "$refid";?></strong>
</td>
</tr>
</table>
</center></div>
<div align="left">
<table border="0" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<b>Status:</b>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<strong><?echo "$status";?></strong>
</td>
</tr>
</table>
</center></div>
<div align="left">
<table border="0" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<b>Nama:</b>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<?echo "$nama";?>
</td>
</tr>
</table>
</center></div>
<div align="left">
<table border="0" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<b>Jawatan:</b>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<?echo "$jawatan";?>
</td>
</tr>
</table>
</center></div>
<div align="left">
<table border="0" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<b>Jenis Cuti:</b>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<?echo "$jenis";?>
</td>
</tr>
</table>
</center></div>
<div align="left">
<table border="0" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<b>Tarikh Cuti:</b>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<?echo "$mula";?> hingga <?echo "$tamat";?>
</td>
</tr>
</table>
</center></div>
<div align="left">
<table border="0" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<b>Jumlah Hari Cuti:</b>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<?echo "$jumlah";?>
</td>
</tr>
</table>
</center></div>
<hr>
<?
$i++;
}
?>
<div align="left">
<table border="0" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="10">
<b>Superior:</b>
<td align="left" valign="bottom" width="70%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="10">
<?echo"$ack_by";?>
</td></tr>
</table>
<div align="left">
<table border="0" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="10">
<td align="left" valign="bottom" width="70%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="10">
<form action="leave_ack_func.php" method="post">
<input type="hidden" name="statusby" value="<? echo $ack_by; ?>" >
<input type="hidden" name="super" value="<? echo $user; ?>" >
<input type="submit" value="ACKNOWLEDGE" name="ack"></form>
</td></tr>
</table>
?>I get confuse where to put the if, else and the {}