Sorting search results

gitosh

Hey people, I'm still on my search system. I'm using microsoft sql as my database.
when a user searchs for a record, the results are returned formated in a table format with rows a columns, at the top of the results is the column headers.
Now what I need to do is be able to sort the results based on the column header that the user clicked. I hope the question is clear.

Thanks all in advance

devinemke

simply add the ORDER BY clause to your queries

leatherback

or.. If you do not want to rerun the query and resubmit yoru search criteria, you could take a plunge with javascript (though this may not work for all users, e.g., js disabled)

http://kryogenix.org/code/browser/sorttable/

gitosh

Hey devinemke I know I need to use the Order by and I'm doing that in my stored procedures and leatherback, I don't think I want to plunge into javascript at this point. As I said earlier, I need to pass a order by variable to the database when a user clicks a particular column, the problem is how to send the variable on click. I'll give you a line of code that has an error and you can tell me where the error is

echo '<td><b><a href="<?=$_SERVER['PHP_SELF']?>?order=OrgName">Organization Name</a></b></td>';

before that I've declared the $order variable and I also have the code that is starting the table and row.
Now, this is the error I'm getting

PHP Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in C:\Inetpub\wwwroot\GeoSearch\UserQuery.php on line 79

what could be the problem guys, thanks in advance.

leatherback

If you use echo, that indicates you are already in a php section of your code:

echo "<td><b><a href=\"".$_SERVER['PHP_SELF']>"?order=OrgName\">Organization Name</a></b></td>";

gitosh

hello leatherback, thanks for the quick reply but I'm getting the same error

leatherback

sloppy me, Had shift pressed for the dot, resulting in a >


echo "<td><b><a href=\"".$_SERVER['PHP_SELF']."?order=OrgName\">Organization Name</a></b></td>";

gitosh

ah! thanks, that error is now gone. Let me proceed and see if I succeed. Thanks alot