|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Sortable tables
This seems to be one of the largest PHP sites. I really don't know much about php and should probably buy a book about it. However....
I'm wondering if it would be pretty simple to set up a sortable table. I would like to set up the <table> I have on my http://zepfanman.com/bibleinf.html page and make it sortable by each column (like mail.yahoo or hotmail does for example). Again, I only know a few <? statements and don't know how to integrate it with MySQL and stuff. My website is on One2host.com and it does support php, but I don't know about any other setups that may be necessary for what I need to do. Please let me know, or if you have any other php forums you could suggest. |
|
#2
|
|||
|
|||
|
RE: Sortable tables
The headers of each column would need to be links to the page and pass that back to the script itself then when the mysql statement retrieves the table just ORDER BY the value passed. This assumes your table headings are the same as your column headings.
instead of <tr><td>Bible</td>..... it would be <tr><td><a href="url?sort=bible">Bible</a></td>..... then your query would be SELECT * from table ORDER BY $_GET['sort'] if this is a little confusing shoot me an email and I can explain it at more length mmabe@hot.rr.com |
|
#3
|
|||
|
|||
|
RE: Sortable tables
I would like to make DESC or ASC the query every time I click into the same header in the table. I can't find the way to make it (my skill in PHP is limited...)
|
![]() |
| Viewing: Codewalkers Forums > PHP Related > PHP Installation > Sortable tables |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|