Databases
StackOverflow2013
Postsdbo
PODatatables for the multiple columns
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODatatables for the multiple columns
    text
    copied!<p>I have a datatable to display the information from pulling from the database. For the eight columns the data are displayed perfectly but when I try to add one more column in html and pull one column information from the database the datatables get screwed up. I have attached my codes herewith for the reference :</p> <p>My html table</p> <pre><code>&lt;table id="datatables" class ="display"&gt; &lt;thead&gt; &lt;tr&gt; &lt;th&gt;University&lt;/th&gt; &lt;th&gt;Country&lt;/th&gt; &lt;th&gt;Total_Pubs&lt;/th&gt; &lt;th&gt;Per Pubs in 10 % SNIP&lt;/th&gt; &lt;th&gt;Per Pubs in Top 25% SNIP&lt;/th&gt; &lt;th&gt;Total Cites&lt;/th&gt; &lt;th&gt; Per Cites from Top 10% SNIP&lt;/th&gt; &lt;th&gt;Per Cites from Top 25% SNIP&lt;/th&gt; &lt;/tr&gt; &lt;/thead&gt; &lt;tbody&gt; </code></pre> <p>Data fetching from the database:</p> <pre><code> while ($row = mysql_fetch_array($result)) { &lt;tr&gt; &lt;td&gt;&lt;?=$row['University_Name']?&gt;&lt;/td&gt; &lt;td&gt;&lt;?=$row['Country_Name']?&gt;&lt;/td&gt; &lt;td&gt;&lt;?=$row['Total_Pubs']?&gt;&lt;/td&gt; &lt;td&gt;&lt;?=$row['Per_Pubs_A1']?&gt;&lt;/td&gt; &lt;td&gt;&lt;?=$row['Per_Pub_A1_A']?&gt;&lt;/td&gt; &lt;td&gt;&lt;?=$row['Total_Cite']?&gt;&lt;/td&gt; &lt;td&gt;&lt;?=$row['Per_Cite_A1']?&gt;&lt;/td&gt; &lt;td&gt;&lt;?=$row['Per_Cite_A1_A']?&gt;&lt;/td&gt; &lt;/tr&gt; } </code></pre> <p>JQUery for the datatables:</p> <pre><code> jQuery(document).ready(function() { jQuery('#datatables').dataTable({ "sPaginationType":"full_numbers", "aaSorting":[[2, "desc"]], "bJQueryUI":true, }); }); </code></pre> <p>Any suggestions and ideas are highly appreciated.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload