Samples Log

while($database_data = mysql_fetch_array($get_data, MYSQL_ASSOC))
            {

                    $request_id = stripslashes($database_data['request_id']);

                        if ($database_data['request_date'] != "0")
                        {
                            $request_date = date("d/m/Y", $database_data['request_date']);
                        }
                        else
                        {
                            $request_date = "-";
                        }

                    $request_smd_number = stripslashes($database_data['request_smd_number']);
                    $request_brief_description = stripslashes($database_data['request_brief_description']);
                    $request_description = wordwrap($database_data['request_description'], 30, '<br />');
                    $request_supplier = stripslashes($database_data['request_supplier']);
                    $request_colours = stripslashes($database_data['request_colours']);

                    $request_required_for = stripslashes($database_data['request_required_for']);

                    // Show only the first paragraph on the sample log
                    $request_comments = explode("<br />", stripslashes(nl2br($database_data['request_comments'])));

                    $request_problems = stripslashes(nl2br($database_data['request_problems']));

                        if ($database_data['request_confirmed_comp_date'] > "0")
                        {
                            $request_confirmed_completion_date = date("d/m/Y", $database_data['request_confirmed_comp_date']);
                        }
                        else
                        {
                            $request_confirmed_completion_date = " -";
                        }

                        if ($database_data['request_confirmed_comp_date2'] > "0")
                        {
                            $request_confirmed_completion_date2 = date("d/m/Y", $database_data['request_confirmed_comp_date2']);
                        }
                        else
                        {
                            $request_confirmed_completion_date2 = " -";
                        }

                        if ($database_data['request_confirmed_comp_date3'] > "0")
                        {
                            $request_confirmed_completion_date3 = date("d/m/Y", $database_data['request_confirmed_comp_date3']);
                        }
                        else
                        {
                            $request_confirmed_completion_date3 = " -";
                        }

                        if ($database_data['request_confirmed_comp_date4'] > "0")
                        {
                            $request_confirmed_completion_date4 = date("d/m/Y", $database_data['request_confirmed_comp_date4']);
                        }
                        else
                        {
                            $request_confirmed_completion_date4 = " -";
                        }

                        if ($database_data['request_confirmed_comp_date5'] > "0")
                        {
                            $request_confirmed_completion_date5 = date("d/m/Y", $database_data['request_confirmed_comp_date5']);
                        }
                        else
                        {
                            $request_confirmed_completion_date5 = " -";
                        }

                        if ($database_data['request_confirmed_comp_date6'] > "0")
                        {
                            $request_confirmed_completion_date6 = date("d/m/Y", $database_data['request_confirmed_comp_date6']);
                        }
                        else
                        {
                            $request_confirmed_completion_date6 = " -";
                        }

                        if ($database_data['request_date_required'] > "0")
                        {
                            $request_date_required = date("d/m/Y", $database_data['request_date_required']);
                        }
                        else
                        {
                            $request_date_required = "-";
                        }

                        if ($database_data['request_date'] > "0")
                        {
                            $request_date = date("d/m/Y", $database_data['request_date']);
                        }
                        else
                        {
                            $request_date = "-";
                        }

                    $request_received = stripslashes($database_data['request_received']);


                    $request_comp_date_array = array($request_confirmed_completion_date6, $request_confirmed_completion_date5, $request_confirmed_completion_date4, $request_confirmed_completion_date3, $request_confirmed_completion_date2, $request_confirmed_completion_date);


                    // Table Code
                    echo '<tbody>';


                    // Switch Light/Dark table row background colours
                    if ($light_dark == "dark")
                    {
                            echo '<tr bgcolor="#F1F1F1" valign="top">';
                            $light_dark = "light";
                    }
                    else
                    {
                            echo '<tr bgcolor="#FFFFFF" valign="top">';
                            $light_dark = "dark";
                    }


                    echo '<td><a style="padding-left: 20px;" href="viewedit.php?id='.$request_id.'"><i class="icon-pencil"></i></a></td>';
                    echo '<td>'.$request_date.'</td>';
                    echo '<td>'.$request_date_required.'</td>';
                    echo '<td>'.$request_smd_number.'</td>';
                    echo '<td>'.$request_supplier.'</td>';
                    echo '<td>'.$request_brief_description.'</td>';
                    echo '<td>'.$request_required_for.'</td>';
                    //echo '<td><b>1.</b>'.$request_confirmed_completion_date.'<br /><b>2.</b>'.$request_confirmed_completion_date2.'<br /><b>3.</b>'.$request_confirmed_completion_date3.'<br /><b>4.</b>'.$request_confirmed_completion_date4.'<br /><b>5.</b>'.$request_confirmed_completion_date5.'<br /><b>6.</b>'.$request_confirmed_completion_date6.'</td>';
                    echo '<td>'.$request_comp_date_array[5].'</td>';
                    echo '<td>'.$request_comments[0].'</td>';
                    echo '<td>'.$request_problems.'</td>';
                    echo '</tr>';

                    echo '</tbody>';

            }

    }

    echo '</table>
';