Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder
    Join Date
    Aug 2010
    Posts
    713
    Thanks
    165
    Thanked 0 Times in 0 Posts

    Need help in using if condition to select query

    Hi..


    Now, I have select query with if condition, that if null the table data <td> will have background-color : red

    here is my code:

    Code:
    $sql = "SELECT DISTINCT IF(ISNULL(a.LOG_IN), 'rdc', '') AS LOGIN_CLASS, IF(ISNULL(a.LOG_OUT), 'rdc', '') AS LOGOUT_CLASS, a.EMP_ID, a.LOG_IN, a.LOG_OUT, CONCAT(LNAME, ',' , FNAME, ' ', MI, '.') AS FULLNAME
     FROM hrdb.attendance AS a JOIN hris.employment em ON (a.EMP_ID = em.EMP_NO AND em.STATUS = 'Reg Operatives') JOIN hris.personal AS p ON p.EMP_ID = em.EMP_ID
     WHERE ATTENDANCE_DATE BETWEEN '2012-06-01' AND '2012-06-15' OR ATTENDANCE_DATE = '0000-00-00'  
     OR ISNULL(a.LOG_IN) OR ISNULL(a.LOG_OUT) ORDER BY FULLNAME, a.LOG_IN, a.LOG_OUT";
    
        $DTR = $conn3->GetAll($sql);
       
        $smarty->assign('attendance', $DTR);
    Code:
    .rdc {background-color:#ff0000;}
     {section name=att loop=$attendance} 
    <table>
    <tr>  
    <td colspan="2" class="{$attendance[att].LOGIN_CLASS}">{$attendance[att].LOG_IN}</td>
    <td colspan="2" class="{$attendance[att].LOGOUT_CLASS}">{$attendance[att].LOG_OUT}</td>  
    {sectionelse}
      <tr><td colspan="1">No DATA</td></tr>
    {/section}

    Now..

    I need to revise my select if condition, because now the LOG_IN and LOG_OUT has no possibilities to have NULL values but now It will have 0000-00-00 00:00:00 values.


    So I need to put background color if the LOG_IN is 0000-00-00 00:00:00 also with LOG_OUT.


    Thank you so much

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts

  • #3
    Regular Coder
    Join Date
    Aug 2010
    Posts
    713
    Thanks
    165
    Thanked 0 Times in 0 Posts
    Sorry..

    If i repost my problem to a lots of forum..

    I need to resolve as soon as possible thats why I repost it.


    I hope you'll understand

    Thank you

  • #4
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,857
    Thanks
    78
    Thanked 4,417 Times in 4,382 Posts
    Quote Originally Posted by newphpcoder View Post
    If i repost my problem to a lots of forum..

    I need to resolve as soon as possible thats why I repost it.

    I hope you'll understand
    No, we don't understand. And we don't answer you, just because you do this.

    At least, I have given up answering you. Even when I have given you answers, you have ignored them as often as not.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •