Sorting recordsets via a link

[reiss]

Hi
have created a database table which contains the following fields -

id, Product, product Image, description, type, price.

have created a recordset and a repeat region to display all the fields neatly organised into a htm table.

I would like to have table headings that give the user options to - sort by price, sort by type and the table reorganises itself, but dont know where to begin. am quite a database noob, so simple is better for me!

am using PHP & MySQL with dreamweaver 8

thanks in advance

[jkrohn]

You can do this either on the client side, or the server side.

Client side javascript a la here: http://www.mattkruse.com/javascript/sorttable/

Server side, use GET variables (SANITIZE THEM!), hit the database again and redisplay data.

Which to use really depends on how much and the types of data you are displaying.

Jkrohn

[reiss]

thanks jkrohn, will have a look a some javascript

[reiss]

was hoping it would be a little simpler! my coding is very novice, been relying on dreamweaver inserts

[jkrohn]

If you want it to be simpler add get variables to links on the header columns or arrows next to them and hit the DB again with a different order by clause.

Jkrohn

[Bootlegger]

Use the ORDER BY clause in your SQL query with ASC or DESC. This is the easiest and most optimal way to go.