How do I externally update a table in my htm file?

[w33nie]

I really have no idea where to start for this, as i'm VERY new to scripting, but i do have intermediate skills at html, so i thought i'd try and get a nudge in the right direction from a help site.

I'm currently making a website where I'll need to have a rankings table of teams for an online computer game league.
I'll put this table in my .htm file, as I want it to be integrated in the page, and look just like a regular table would.
but, I want to be able to externally update the data in this table, so I don't have to change the .htm file after every match, updating the teams, their positions on the table and the rest of the data.

the primary aim of this method for me, is for ease of use.
i would also like this external file to be able to sort the positions of teams on the table for me, based on the points this team has won.

so, does anyone know of a format of file or external source i could use? like PHP or another script?
and how i would achieve this goal.


cheers.
rowan.

[AricC]

What do you have available PHP,ASP, etc... I'm going to move this thread to the appropriate forum.

[w33nie]

umm, ive got mySQL and PHP4/PHP5 available to use in the hosting plan, but i just lack any knowledge of coding in them.

which one do you think would be more appropriate? for the basic aims i'm trying to achieve.

[AricC]

PHP4/PHP5 are the versions the main thing is that you can run PHP on your site. I'm going to move this thread to the PHP forum.

[ronverdonk]

First you have to make a choice between storing the data in a flat text file or in a MySQL database.

Both solutions can be externally updated via a grid script and both can be read, sorted and stored into your html page.

MySQL is easier to handle and program, but has more server overhead. A flat file is more difficult (column positions etc.) to program but has less overhead.

So it's up to you to first decide how and where you want your data to be stored.

Ronald :cool:

[w33nie]

well i think as a complete beginner i should use mySQL, if its easier.
i'll only need a maximum of 72 text fields in the table, so there shouldn't be too much server overhead, right?

so if i'm to use mySQL, could you point me to a decent tutorial for integrating it into a table in html?
i havent downloaded mySQL though, and havent a clue what to do once i have got it, anyway.

thanks for all the help in advance.

[ronverdonk]

There are a lot of decent to good tutorials, depending on your requirement. Try any (or all) of the following MySQL tutorials

http://www.devshed.com/c/a/MySQL/Beg...ySQL-Tutorial/
http://www.freewebmasterhelp.com/tutorials/phpmysql
http://www.tizag.com/mysqlTutorial/
http://www.sitepoint.com/subcat/php-tutorials
http://www.php-mysql-tutorial.com/
http://bmw.ws.utk.edu/nsu/php/
http://www.developer.com/lang/php/article.php/3288671
http://www.w3schools.com/php/php_mysql_intro.asp

Good luck.

Ronald :cool:

[w33nie]

thanks.
well... currently, im on the freewebmasterhe lp tutorial.
i've downloaded mySQL, gotten an account, and am trying to set up phpMyAdmin, but the setup.php file won't open in IE or firefox... and i need it to. otherwise i cant use phpMyAdmin.

what do you suggest i do?

[ronverdonk]

I'd suggest that you forget about phpMyAdmin for now and setup your MySQL server first using the command line interface. You'll learn more about Mysql and the SQL statements using that. If not, you can also execute SQL via a server script, like PHP.

First get your server setup right, then worry about the user interface like phpMyAdmin.

Ronald :cool:

[w33nie]

well i really have no idea what i'm doing, and the server won't set up properly.

so, the other option, a flat text file.
how do i integrate that with my html file, and will it allow automatic sorting based on the information in the flat text file?