homepage Welcome to WebmasterWorld Guest from 54.204.215.209
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe and Support WebmasterWorld
Home / Forums Index / Code, Content, and Presentation / JavaScript and AJAX
Forum Library, Charter, Moderator: open

JavaScript and AJAX Forum

    
How to reorder from a query
helenp




msg:4374677
 9:38 pm on Oct 14, 2011 (gmt 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,

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / JavaScript and AJAX
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved