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)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Nov 27, 2003
votes: 0

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,

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members