Modifying Table Elements

[shaunk]

I am building a footy tipping website and would like to auto-populate a table with the weeks teams.
Can anyone point me to a good reference guide on the net for accessing and modifying table elements.

For Example:

The table looked like this before selecting the round:

<table>
<tr>
<td>&nbsp</td>
<td>&nbsp</td>
</tr>
</table>
and so forth...one row for each game.


After selecting the round....I would access a database to extract the teams for each game in each round and modify the table to look like:
table>
<tr>
<td>Jets</td>
<td>Reds</td>
</tr>
...and so on

 

[ChrisHirst]

there are lots of resources around but it depends on what server side language you can run (PHP, ASP, CF etc) and what database you can use (Access, MS SQL, MySql etc).



Chris.

Indifference will be the downfall of mankind, but who cares?

 

[shaunk]

I'm using ASP and probably Access at first.
I was tinkering with the idea of using a two or three dimensional array/s, hard-coded at first, and then populate the table from that. From there, I was then going to develop a method of populating the array/s from a D/B.
However, on second thought I should probably sort out the D/B before progressing and then revisit.
Thanks

 

[ChrisHirst]

definitely get the order right. design and structure the database first.

arrays aren't really needed you can just retrieve the data and display it staight to the page. all the arrays will do is take up resources on the server. With a db in place you open the db read the data. display it and close the db.

http://www.asp101.com

have some good primer articles and samples on database coding with ASP vbscript.



Chris.

Indifference will be the downfall of mankind, but who cares?