Tablesorter - sorting not happening

Tablesorter - sorting not happening

Hi

I'm new to jquery and am looking for some advice.  I found some sample code, uploaded it to my site and got it working fine, so pretty content that the path to the jquery is working fine. I've since tried substituting my own table into the code instead, which has stopped the sorting from working correctly.  The main difference that I can see is that the contents of my table is being pulled from a database. 

Output: http://www.arabianraceform.co.uk/form/horses/00001test.php

Page code:
  1.  <?php    $result = mysqli_query($con,    "SELECT     runners.raceid, runners.weight, runners.rat, runners.eqp, runners.pos, runners.beat, runners.plus, runners.price, runners.jockey, race.raceid, race.dateshort, race.cshort, race.racetype, race.distf, race.run, race.ground, race.raceurl
  2.  FROM  runners
  3.  Inner Join race On
  4. runners.raceid = race.raceid
  5. WHERE        runners.horse = 'Wikkara'
  6. ORDER BY    runners.raceid DESC"); ?>                                     
  7. <?php include($_SERVER['DOCUMENT_ROOT'].'/inc/tables/horses.php');?>           
  8. <?php mysqli_close($con);?>    

Table insert code:


  1. <?php
  2.         echo "<table id='keywords'>
  3.         <thead>
  4.         <tr>
  5.         <th>Date</th>
  6.         <th>Course</th>       
  7.         <th>Race Type</th>   
  8.         <th>Dist</th>
  9.         <th>Going</th>
  10.         <th>Weight</th>
  11.         <th>Rating</th>
  12.         <th>Eqpt</th>
  13.         <th>Pos</th>
  14.         <th>Beaten</th>
  15.         <th>Jockey</th>       
  16.         <th>Price</th>           
  17.         </tr>
  18.         </thead>";
  19.         while($row = mysqli_fetch_array($result)) {
  20.        
  21.         include($_SERVER['DOCUMENT_ROOT'].'/inc/links.php');
  22.          
  23.           echo "<tbody>";         
  24.           echo "<tr>";
  25.           echo "<td>";
  26.           echo "<a href=".$racelink . ">" .$row['dateshort'] . "</a><br>";
  27.           echo "<td>" . $row['cshort'] . "</td>";
  28.           echo "<td>" . $row['racetype'] . "</td>";
  29.           echo "<td>" . $row['distf'] . "</td>";         
  30.           echo "<td>" . $row['ground'] . "</td>";         
  31.           echo "<td>" . $row['weight'] . "</td>";
  32.           echo "<td>" . $row['rat'] . "</td>";
  33.           echo "<td>" . $row['eqp'] . "</td>";
  34.           echo "<td>" . $row['pos'] . "/" . $row['run'] . "</td>";
  35.           echo "<td>" . $row['beat'] . "" . $row['plus'] . "</td>";
  36.           echo "<td>" . $row['jockey'] . "</td>";         
  37.           echo "<td>" . $row['price'] . "</td>";         
  38.           echo "</tr>";
  39.           }
  40.         echo "</tbody>";
  41.         echo "</table>";?>
  42.        
  43.         <script type="text/javascript">
  44. $(function(){
  45.   $('#keywords').tablesorter();
  46. });
  47. </script>


CSS Code for tablesorter


  1. table
  2. {
  3. border-collapse:collapse;
  4. width:100%;
  5. }
  6. #keywords {
  7.   margin: 0 auto;
  8.   font-size: 1.2em;
  9. }
  10. #keywords thead {
  11.   cursor: pointer;
  12.   background: #c9dff0;
  13. }
  14. #keywords thead tr th {
  15.   font-weight: bold;
  16.   padding: 2px 2px 2px 2px;
  17. }
  18. #keywords thead tr th span {
  19.   padding-right: 20px;
  20.   background-repeat: no-repeat;
  21.   background-position: 100% 100%;
  22. }
  23. #keywords thead tr th.headerSortUp, #keywords thead tr th.headerSortDown {
  24.   background: #acc8dd;
  25. }
  26. #keywords thead tr th.headerSortUp span {
  27.   background-image: url('/images/tables/up-arrow.png');
  28. }
  29. #keywords thead tr th.headerSortDown span {
  30.   background-image: url('/images/tables/down-arrow.png');
  31. }
  32. #keywords tbody tr {
  33.   color: #555;
  34. }
  35. #keywords tbody tr td {
  36.   text-align: center;
  37.   padding: 2px 2px 2px 2px;
  38. }
  39. #keywords tbody tr td.lalign {
  40.   text-align: left;
  41. }
  42. #keywords td, #keywords th, #keywords table 
  43. {
  44. border: 1px solid black;
  45. }

Any advice would be greatly appreciated.