i need help php and sql script

[Gaurav]

just assign a class to the table row in case $today >= $date and style it the way you want in the stylesheet.

                                        echo "<thead><tr><th>Date</th><th>Service Report No</th><th>Hospital Name</th><th>Description</th><th>Model No</th><th>Serial No</th><th>Date of Installation</th><th>PPM Due date</th><th>Warranty</th></tr></thead>";  
                                       $today            =  new DateTime("now");  
                                          
                                        while ($row = $result->fetch_object())  
                                        {  
                                                $bgclass = "gradeX ";
                                                $date = new DateTime($row->ppmduedate);  
                                                if ($today >= $date) {$bgclass = "expireWarn"}  
                                                $due = $date->format("m-d-Y");  
                                                // set up a row for each record  
                                                echo "<tr class=$bgclass>";  
                                                  
                                                echo "<td>" . $row->dateinsrep . "</td>";  
                                                echo "<td>" . $row->servicereport . "</td>";  
                                                echo "<td>" . $row->hospitalname . "</td>";  
                                                echo "<td>" . $row->description . "</td>";  
                                                echo "<td>" . $row->model . "</td>";  
                                                echo "<td>" . $row->serial . "</td>";  
                                                echo "<td>" . $row->dinstall . "</td>";  
                                                echo "<td>" . $date ."</td>";  
                                                echo "<td>" . $row->warranty . "</td>";  
                                                echo "</tr>";  
                                        } 

in your CSS, for instance to change the background of the row to red, something along the lines of:

.expireWarn {
    background-color: red;
    color: #fff;
} 

Feel free to play around with the font/background colors

Regards,
Gaurav

Gaurav Reviewed by Gaurav on 26th Feb 2012. i need help php and sql script I am making in this database should help me see my database images http://vvcap.net/db/KWBZVLTBV8XJYL-0YKBb.png PPM Due Date in the day, as it becomes red in the table. like: today date is: 28-02-2012, today agha khan product is expire to auto change color this table and i want to change date format like: D-M-Y please help me Rating: 5

[softpk]

sir no this code is not work show this error

Catchable fatal error: Object of class DateTime could not be converted to string in G:\WampDeveloper\Websites\DefaultWebsite\webroot\d atabase\ins-view.php on line 455

455 Line is:

// set up a row for each record
echo "<tr class=$bgclass>";


and i am using code

 $today  =  new DateTime("now");  
                                
                                // display records in a table
                                        echo "<div class='mws-panel grid_8'>";
                                        echo "<div class='mws-panel-header'><span class='mws-i-24 i-table-1'>Installation Report</span></div>";
                                        echo "<div class='mws-panel-body'>";
                                        echo "<table class='mws-datatable mws-table' id='example'>";
                                        
                                        // set table headers
                                                   
                                        echo "<thead><tr><th>Date</th><th>Service Report No</th><th>Hospital Name</th><th>Description</th><th>Model No</th><th>Serial No</th><th>Date of Installation</th><th>PPM Due date</th><th>Warranty</th></tr></thead>";
                                        
                                        
                                         while ($row = $result->fetch_object()) 
                                        { 
                                                $bgclass = "gradeX";
                                                $colorPrefix = ''; 
                                                $colorSuffix = ''; 
                                                $dateinsrep = new DateTime($row->dateinsrep);
                                                $dinstall = new DateTime($row->dinstall);
                                                $date = new DateTime($row->ppmduedate); 
                                                if ($today >= $date) {$bgclass = "expireWarn";}
                                                $due = $date->format("d-m-Y");  
                                                $due = $dateinsrep->format("d-m-Y");
                                                $due = $dinstall->format("d-m-Y");
                                         
                                        
                                                // set up a row for each record
                                                echo "<tr class=$bgclass>";
                                                
                                                echo "<td>" . $dateinsrep->format("d-m-Y") . "</td>";
                                                echo "<td>" . $row->servicereport . "</td>";
                                                echo "<td>" . $row->hospitalname . "</td>";
                                                echo "<td>" . $row->description . "</td>";
                                                echo "<td>" . $row->model . "</td>";
                                                echo "<td>" . $row->serial . "</td>";
                                                echo "<td>" . $dinstall->format("d-m-Y") . "</td>";
                                                echo "<td>" . $date . "</td>";
                                                echo "<td>" . $row->warranty . "</td>";
                                                echo "</tr>";
                                        }