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

This is a discussion on "Looking for Script to sort table data (& populate database)" within the PHP Forum section. This forum, and the thread "Looking for Script to sort table data (& populate database) are both part of the Program Your Website category.



Go Back   Webforumz.com > Main Forums > Program Your Website > PHP Forum

Notices


Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old Oct 10th, 2006, 17:54
New Member
Join Date: Oct 2006
Location: California
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
[Resolved] Looking for Script to sort table data (& populate database)

Edit - Pointed to a nice javascript for sorting here: http://www.frequency-decoder.com/2006/09/16/unobtrusive-table-sort-script-revisited

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 php). 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? 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

Last edited by toasty; Oct 11th, 2006 at 16:57. Reason: solved
Reply With Quote

  #2 (permalink)  
Old Oct 13th, 2006, 17:42
masonbarge's Avatar
Highly Reputable Member
Join Date: Jan 2006
Location: Atlanta GA
Posts: 631
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Looking for Script to sort table data (& populate database)

You really want a database and php (or asp) if the table is going to get very big. This is probably the most basic and most efficient use of php/mysql. But you have to understand what you're doing, i.e. have to learn the most basic level of coding.
Basic mysql is really easy if you use a graphic interface (such as phpMyadmin). For a tiny table like yours, it is almost completely intuitive.

Basic php, including simple mysql queries, would take maybe 40 hours of study/practice, including drafting your project and learning basic security.

The front end takes more time, but once it's done, it practically runs itself.
Reply With Quote
Reply

Tags
php mysql table

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Some sort of database in flash? Throntel Flash & Multimedia Forum 3 Jan 6th, 2007 05:54
XML Code for transfering data from one SQL Server Database to another database plolla Other Programming Languages 1 Aug 3rd, 2006 18:37
displaying data from my database franknu PHP Forum 20 Jun 16th, 2006 09:43
ACCESS: one table one data,and only one! Monie Databases 1 Aug 2nd, 2004 09:00
How should I populate the following table. macupryk Databases 1 Oct 15th, 2003 23:34


All times are GMT. The time now is 11:58.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43