Tablesorter plugin not sorting my tables when data comes from database

I have the following code:

<table id="box-table-a" class="tablesorter">
<thead>
<tr>
<th scope="col">B-House/Dorm Name</th>
<th scope="col">Address</th>
<th scope="col">Price Range</th>
<th scope="col">Date Added</th>
<th scope="col">Status</th>
</tr>
</thead>
 <?php
$q=mysql_query("select * from property");
while( $f=mysql_fetch_array($q, MYSQL_ASSOC))
{                                       $p_id=$f["p_id"];                                    
 echo"
<tbody>
<tr>
<td onblurr='hover2()' onmouseover='hover(".$p_id.")' onclick='showUser(".$p_id.")'>
<span style='cursor开发者_如何转开发:pointer'>".$f['p_name']."</span></td>
<td id='pretty'>".$f['address']."</td>
<td>".$f['p_name']."</td>                           <td>".$f['payment_type']."</td>                         <td>".$status."</td>                                    </tr>       
</tbody>
";
}
?>
</table>

Any idea what may be wrong here?

Don't add <tbody></tbody> to every loop in the while! Tablesorter is very sensitive.

You did'nt sort your DB :

$q=mysql_query("select * from property ORDER BY p_name");