I want to Auto generate Employee ID if department == HRa && Status == permanent , if

[rafaykhan15]

<?php
 if($comp == 1)  {   
    $sel_id= "SELECT MAX(emp_id)+1 from employee where company = 1";
    $sel_exeid=mysql_query($sel_id)  or die(mysql_error());
    while($empid= mysql_fetch_array($sel_exeid))
    { 
       $result = $empid[0];
    }  
 }  
 else 
 {
    $sel_id= "SELECT MAX(emp_id)+1 from employee where company = 0 ";
    $sel_exeid=mysql_query($sel_id)  or die(mysql_error());
    while($empid= mysql_fetch_array($sel_exeid)) 
    {
       $result = $empid[0];
    }  
 } 
 ?> 
 
 <tr>
    <td align="center" >
       <input name="eid" type="text" class="txtInput" id="eid" value="<?php echo $result;?>" placeholder="Enter Employee Id"/>
    </td>
 </tr>

[Rabbit]

I don't know what your question is... Your title got cut off, you should have posted the question in the body of the post.