query checking....

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
g3ckO
Forum Contributor
Posts: 117
Joined: Mon Jul 12, 2004 2:57 am
Location: Malaysia
Contact:

query checking....

Post by g3ckO »

This is my query:

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);
?>
and this will execute from the query:

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> 

?>
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 {} :roll:
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Code: Select all

if ($num == 0)
{
// print no records type stuff
}
else
{
// do your while loopy thing
}
?>
Post Reply