Sorting a table

[nagmvs]

Hello

I have a table with 20 rows and 8 columns,i want to sort the table when i click the column.can any one tell me what is the query for that ?

for example i wrote the query as

sqlqr="Select #_id,Id_id,Name_name,Team_name1,Job_no,qc_id,Type_id,Error_id,Acc from infos_today where Team_name='"&GMTS&"' and job_no <> '' order by "& sort_var &" desc"
 

so please tell me the query.
Thanks,
nagesh.

[Atli]

Hi.

I suspect that this is not a MySQL query. Am I right?
I also suspect this is the same question you posted here today, and here four days ago.

If that is the case, please do NOT double post your questions. Far from increasing your chances to get an answer, it will only cause confusion (especially when posted in the wrong forums) and it may even result in you being banned from these forums.

Even if that is not the case, to accomplish this you would have to have some sort of a "front-end" application. Like a web-page or such, where your data is displayed and where the user presumably selects which columns he wants the data sorted by.

We can't help you unless we know what that "front-end" application is, and how you designed it.

P.S.
Please use [code] tags when posting your code examples, and read the Posting Guidelines before posting!

MODERATOR