Jump to content


Photo

[Resolved] Looking for Script to sort table data (& populate database)


  • Please log in to reply
2 replies to this topic

#1 toasty

toasty
  • Members
  • PipPipPip
  • Advanced Member
  • 32 posts

Posted 10 October 2006 - 05:45 PM

I'm not exactly sure if this is the right location for this post, so my appologies if it belongs elsewhere :)

I'm wondering if anyone might know of a prebuilt script that I can use to do the following:

There are two things I want to do: (1) Make the data in a table on one of my pages sortable. (2-optional) Update/enter the data in a MySQL database.

Currently I have a page on my site that displays data in a table consisting of five colums that include values of text (including an href), numeric/decimal, and date.  Right now, whenever I need to update the table I have to add a new row and populate the colums with their data (via html).  All the info is housed on that webpage.

This seems like it should be something fairly simple, however I'm having a hellofa time finding a prebaked database/script to impliment at least one of these features.  If I had the time I would learn how to code it all myself, but I'm looking at a time frame of a couple days before I need it online.

Does anyone have any ideas of a script that, at the very least, would do the table sorting?  Preferably handling the database as well (though optional, like I mentioned).  Did I mention "free" would also be a nice feature? :D  I've searched online and found a few that handle the sorting but their coding seems a bit off and usually ends up screwing up the java on the rest of my page.

I'm open to any thoughts or suggestions and I really appreciate even the most miniscule amount of help :)

#2 HuggieBear

HuggieBear
  • Members
  • PipPipPip
  • Advanced Member
  • 1,899 posts
  • LocationEngland, UK

Posted 10 October 2006 - 10:41 PM

I think if you followed the W3Schools link in my signature and go through the SQL tutorial, you'd have the database up and running with your data in within two - three hours.  Once you have that done, we can help you with the rest I'm sure.

Regards
Huggie
Advice to MySQL users: Get phpMyAdmin and test your queries work there first, take half the hassle out of diagnosis, also check the reserved words list.

Links: PHP Docs :: RegEx's :: MySQL :: DevGuru :: w3schools

#3 toasty

toasty
  • Members
  • PipPipPip
  • Advanced Member
  • 32 posts

Posted 11 October 2006 - 04:41 PM

In hind sight, 2-3 hours would have been pretty good given that I spent about 10 hours yesterday troubleshooting a (rather nice) javascript that was able to achieve what I was looking for.  It's nice having one more milestone behind me.  Thanks for the links though Huggie, I took a look at the W3 link and have a feeling I'll have use for it at some point; at the very least it's something to add to my arsenal.

Thanks!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users