Welcome to Geeklog, Anonymous Wednesday, June 19 2024 @ 09:20 am EDT

Geeklog Forums

Creating 'sortable' Static Page?


Anonymous

Anonymous
I am new to the world of PHP and MYSQL so bare with me if (A) This is impossible or (Cool Blatantly easy. My goal is to create a master index of links with in my site sortable by a field. I have no problems creating an extra table to hold these values but how would I populate a static page with the results and allow sorting? If this doesn't make sense, what I am trying to do is similar to that where are review sites you can sort by title or date or price or $$$. I want to give my users this ability so they can quickly find what they are looking for. Thanks!
 Quote

Anonymous

Anonymous
Do you mean like this?
 Quote

Anonymous

Anonymous
Yes-Yes-Yes! That's it?? Can you help out a guy?
 Quote

Anonymous

Anonymous
Actually, yes, I have seen that page by Tom at the pig stye. My question is can you limit what topics it indexes? I would only 4 or 5 of my topics indexed.
 Quote

Anonymous

Anonymous
He took Tom W's site index script and added a little code to make the columns sortable. He described what he changed here If the changes are above your head, you can probably just write to him (at jerry@hoboes.com)and ask for a copy of the code.
 Quote

Anonymous

Anonymous
Yes, just add a condition to the SQL queries in the script to only select whatever topics you want.
 Quote

Anonymous

Anonymous
Hmm, but I notice in Tom's original page, at least the version I have that the column headers are not clicable, thus they aren't sortable?
 Quote

Anonymous

Anonymous
Right. Another guy was the one who added some code to make the columns clickable and sortable. Tom didn't added this feature to his. Many of these developers don't unless the code is written by them or their close buddies.
 Quote

Anonymous

Anonymous
Yea, I found the modded code but it looks like the guy modded it even further and added some cool horizontal lines on the topic sort. Trying to hunt him down now to see how he did it. I think it's a slick script when it's all put together.
 Quote

Status: offline

tomw

Forum User
Full Member
Registered: 08/12/02
Posts: 300
Just to clear some confusion. When I first made the page I had the columns sortable, but I noticed that this made the google bot somewhat confused and he kept on getting the same page with different sorts. Since I made this page for the google bot, I simplified it by removing the sorting headers. My page is not really meant for human consumption. One of the beauties of the open source way of doing things is that people with different needs can take a piece of code and modify it for their needs. I did not just fail to include the sortable code option, because the submitter was not my friend, but I did it because it did not fit my purpose. If I was making an index for human comsumption, It would include not only sortable headers, but also filters and search. See my Contact plugin for an example of what I mean. TomW
 Quote

jerry

Anonymous

I just made the PHP source for my variation of the siteindex page available as a gzip. I placed it in a quick article at Cerebus the Pope.

I also added the left menu that you wanted.

Jerry

---
"Give a man a fish, and you've fed him for a day. Teach him to fish, and you've depleted the lake."--It Isn't Murder If They're Yankees

 Quote

Anonymous

Anonymous
Thanks Jerry! This is awesome..
 Quote

All times are EDT. The time is now 09:20 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content