Please solve this problem

[softpk]

Dear sir,

I am writing a long description table torn out of its frame is lost.. please help me.. see this picture




i am using jquery.DataTable

My DB Code is:

<?php
                        // connect to the database
                        include('connect-db.php');
                        
                        // get the records from the database
                        if ($result = $mysqli->query("SELECT * FROM insrep ORDER BY id"))
                        {
                                // display records if there are records to display
                                if ($result->num_rows > 0)
                                {
                                
                                // 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'>";
                                        
                                        // 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())
                                        {
                                                // set up a row for each record
                                                echo "<tr class='gradeX'>";
                                                
                                                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>" . $row->ppmduedate . "</td>";
                                                echo "<td>" . $row->warranty . "</td>";
                                                echo "</tr>";
                                        }
                                        
                                        echo "</tbody>";
                                        echo "</table>";
                                        echo "</div>";
                                        echo "</div>";
                                }
                                // if there are no records in the database, display an alert message
                                else
                                {
                                        echo "No results to display!";
                                }
                        }
                        // show an error if there is an issue with the database query
                        else
                        {
                                echo "Error: " . $mysqli->error;
                        }
                        
                        // close database connection
                        $mysqli->close();
                
                ?>

how to possible here are 10 character show in the table and see the preview, the full description.


sorry my english is very bad. I'm trying to understand..


Thank You

softpk Reviewed by softpk on 28th Feb 2012. Please solve this problem Dear sir, I am writing a long description table torn out of its frame is lost.. please help me.. see this picture http://vvcap.net/db/9G3CMUrJB3EqgN9mzZ71.png i am using jquery.DataTable My DB Code is: Rating: 5

[soft2050]

You could try to use css max-width property: http://www.w3schools.com/cssref/pr_dim_max-width.asp

Or use old html <table width="_px">

[Gavo]

This site is using a hacked database of W junction

[Lock Down]

What do you want to do? lengthen the headers to match the data or shorten the data to match the headers?

[Apathetic]

Set the table's width

[Lock Down]

That didn't answer my question. So I will guess....

You need to set the class mws-datatable mws-table width to auto for each div and table.