Sorting list or db numericly and displaying it in table in browser-best way to do it?
I run my website http://www.andrew-winchester.com to promote my motor racing
On the right hand side of the index I have a top 10 points standings table which I update after every race. I also have a full list of points in my results section.
At the moment I use an excel spreadsheet to calculate points and order them and then I have to change the table information by hand, which is time consuming and I feel unnessacery.
I have tried using the import tabular date option in Dreamweaver and importing a .txt I exported from Excel but it loads in a default table which I then have to reformat to my CSS style and then change the background colour on every 2nd line to match my design.
So what I'm looking for is a hassle free way of updating both the top 10 standings and full standings. Where I can simple type into a database or update a file with the points and my website will update itself keeping the correct table and text styles, colours and sizes.
I dont know the best way to do this or there may be multiple ways to achieve this. It would be worth mentioning I am not very good at any kind of coding and only have a moderate knowledge of html and very very basic knowledge of php.
Any help is greatly appreciated
pr0gr4mm3r posted this at 16:15 — 15th January 2007.
He has: 1,502 posts
Joined: Sep 2006
On your homepage, if you imported the data to a database, getting the top 10 is as easy as:
SELECT * FROM Results ORDER BY Points DESC LIMIT 10
Then step through the records and display accordingly.
A simple php script could be used to import a .txt file into a database.
andreww87 posted this at 17:09 — 15th January 2007.
They have: 2 posts
Joined: Jan 2007
that sounds quite simple but where do I put the SELECT * FROM Results ORDER BY Points DESC LIMIT 10
How do i setup a database and i dont know any php to create a script to import the data
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.