Sortable Surfing Display

The following table and its data is being pulled from a mySql database that I created called surfing. This is a sortable display where a user can either select to filter by Ocean and can sort by either ID, Beach, Region or Country when they click the link in the column heading.




IDBeachRegionCountryOceanWave HeightDescription
1 Waikki Oahu Hawaii, USA Pacific 20+ Surfing's Origin
2 Papara Tahiti Fr. Polynesia Pacific 20+ Postcard Beach
3 Buzios Rio deJaneiro Brazil Atlantic 8+ Brazil, enough said
4 Jeffrey's Bay Africa So Africa Indian 8+ Billabong Fest.
5 Tamarindo Central Amer. Costa Rica Pacific 9 Endless Summer
6 Surfer's Paradise East Coast Australia Pacific 12 Unrivaled Cond.
7 Isla Esenada Central Amer. Panama Pacific 8 World Class
8 Huntington California Hawaii, USA Pacific 10 Surf City
9 Kandahar West Coast Mexico Pacific 15 Playa Majahau
10 Lanzarote Canary Islands Spain Atlantic 6 Europe's Best


SQL Query: SELECT * FROM surfing