Problem in NULL value

[newphpbees]

Hi...

i have table

EMP_NO

LOGIN - DATETIME, NULL

LOGOUT - DATETIME, NULL

 

I have this query:

 

<?php

include 'config.php';

$currentEmpID = $_SESSION['empID']; 

if(!isset($_POST['submit_'])){ 
     
    $DATE1 = $_POST['firstinput'];
    $DATE2   = $_POST['secondinput'];
    
  
$sql = "SELECT EMP_NO, LOGIN, LOGOUT  FROM employee_attendance WHERE DATE(LOGIN) BETWEEN '$DATE1' AND '$DATE2'";
    $attendance = $conn3->GetAll($sql);
   
    $smarty->assign('attendance', $attendance);

}
$smarty->display('header_att.tpl');
$smarty->display('empAttendance.tpl');
$smarty->display('footer.tpl');
  
?> 

 

My problem is I have data

EMP_NO 00000223

LOGIN NULL

LGOUT NULL

 

this data was not displayed because it has a null value.. i want it to displayed also and highlight it because it has a value null..

 

Thank you

[SergeiSS]

You have to check the part of your code where you display your data. Here you didn't show this code.

[scootstah]

How is it going to be displayed if its null?

[newphpbees]

This is my new code...my problem now is highlighting with null values

 

 

Now also I need to highlight the data which has a NULL value.

 

I have this revised code:

if(!isset($_POST['Regsubmit_'])){ 
     
    $DATE1 = $_POST['Regfirstinput'];
    $DATE2   = $_POST['Regsecondinput'];


$sql = "SELECT a.EMP_NO, CONCAT(LNAME, ', ' , FNAME, ' ', MI) AS FULLNAME, a.LOGIN, a.LOGOUT
FROM $ATTENDANCE.employee_attendance AS a LEFT JOIN $ADODB_DB.employment em ON a.EMP_NO = em.EMP_NO 
LEFT JOIN $ADODB_DB.personal p ON em.EMP_ID = p.EMP_ID WHERE DATE(LOGIN) BETWEEN '$DATE1' AND '$DATE2' 
AND em.STATUS IN ('Reg Operatives', 'Reg Staff ') OR LOGIN IS NULL";
    $DTR = $conn3->GetAll($sql);
    
$LOGIN = $DTR->fields['LOGIN'];

if($LOGIN == NULL){
// I dont know how can I add stylesheet here so that if it has a NULL value it will have a background color RED
}
   
    $smarty->assign('attendance', $DTR);

}

 

<div id="attendance" style="width: 580px; height: 420px; overflow: auto; padding: 5px; top:95px">
<fieldset>
<legend>Employee Attendance</legend>
<table border="1">
<tr>
<td colspan="2" style="text-align:center">Employee No</td>
<td colspan="2" style="text-align:center">Employee Name</td>
<td colspan="2" style="text-align:center">Time In</td>
<td colspan="2" style="text-align:center">Time Out</td>
</tr>

{section name=att loop=$attendance}
  <tr>
    <td colspan="2">{$attendance[att].EMP_NO}</td>
    <td colspan="2">{$attendance[att].FULLNAME}</td>  
    <td colspan="2">{$attendance[att].LOGIN|date_format:"%d-%m-%Y %I:%M %p"}</td>
    <td colspan="2">{$attendance[att].LOGOUT|date_format:"%d-%m-%Y %I:%M %p"}</td> 
  </tr>
{sectionelse}
  <tr><td colspan="1">No DATA</td></tr>
{/section}
</table>
</fieldset>
</div>

 

Thank you