SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Guru
    Join Date
    Oct 2011
    Posts
    658
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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. #2
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,708
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  3. #3
    SitePoint Guru
    Join Date
    Oct 2011
    Posts
    658
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,270
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by newphpcoder View Post
    I need to resolve as soon as possible thats why I repost it.
    you seem to be really good at posting tiny little problems in multiple forums, hoping to cast a wide enough net that somebody is sure to do your work for you

    you've been doing it for months and months

    my advice is... learn how to fix your own problems

    feeding time is over
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    SitePoint Guru
    Join Date
    Oct 2011
    Posts
    658
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I tried this code and it works:

    Code:
    <td colspan="2" class="{$attendance[att].LOGIN_CLASS}{if $attendance[att].LOG_IN == "0000-00-00 00:00:00"} rdc{/if}">{$attendance[att].LOG_IN}</td>
    Thank you so much


Bookmarks

Posting Permissions

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