Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

How to reorder from a query



9:38 pm on Oct 14, 2011 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member

Hi, I have been all day trying to reorder using jquery and jQuery tablesorter, however it only sort by the first row. It works perfect with the testexampel so the problem is in my php, or its not posible the way I am writing the query.
Dont know if to post in php or here,
I have a searcherbox with severals queries to mysql and the queries have a default order. I want my clients to be able to reorder the result.

This is the phpcode I need to reorder:

echo "<table class='tabla' border='0'> \n";
do {
echo "<tr>";
echo "<td class=searchertop><p><a href=".$row["link_ingles"].">".$row["id_propiedad"]."</a><br>".$row["text"]."<br>Pool: ".$row["pool"]."<br>Bedrooms: ".$row["bedrooms"]."<br>Bathrooms: ".$row["bathrooms"]."<br>Air-conditioning: ".$row["air"]."<br>Sleeps max.: ".$row["duermen"]." persons.<br>Internet: ".$row["internet"]."<br>Prices from: ".$row["price"]." /week.</p><a href=".$row["link_ingles"].">View details</a><p></p></td>";
echo "<td class=searchertop>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href=".$row["link_ingles"]."><img class=borderfotos src=".$row["image"]." border=\"0\"></a></td>";
echo "</tr>";
echo "<td class='result'>&nbsp;</td>";
echo "<td class='result'>&nbsp;</td>";
} while ($row = mysql_fetch_array($result));

echo "</table> \n";

If anybody can help thanks,

Featured Threads

Hot Threads This Week

Hot Threads This Month