The-Lottery.info and ODBC in PHP

17:18.20 - Tuesday 17th February 2004   (Link to This Entry)

I've had a quick look at reading a DataSourceName and it turns out that PHP - again - makes it quite easy to do. It's a whole lotta new commands to remember but it's not like it's going to kill me. This means I'm going to be able to convert even the biggest of the databases with a single script and it should be speedy into the bargain. Now all I have to do is sort out a completely new database format and away we go.

I am toying with the idea of creating a table of results for each game, so that each set would be in their own table, completely seperate from the others. This is the opposite to the current method which has them all in the same table with different fields used, creating a little bit of waste but, truth be told, not that much. The main reason I'm thinking this way is so that, if another game is introduced, I don't have to worry about adding extra fields into an already-populated table - I just start a new one. Each game type has a unique ID anyway, and this can be utilised by creating tables called RESULTS1, RESULTS2 etc.

So tonight I think I'm going to have a bash at converting the tables and making a start on the Admin area, which is where all the work is going to be to start with. Seperate tables may mean that I need to have seperate tables for user lines of different game types, which is going to be a pain when it comes to comparing, or it may not, I won't know until I get started.

F*cking Netscape and the 100%-high Tables.

19:49.28 - Tuesday 17th February 2004   (Link to This Entry)

FOR THE LOVE OF DOG! WHY MUST NETSCAPE MAKE THINGS TO BLOODY DIFFICULT!?!?

*Cough*. I have just discovered that if you want a table 100% the height of the screen, but you want that table centred, you must use ALIGN="CENTER" rather than dropping CENTRE tags around the table, or Netscape will not make it 100% high.

AAAAAAAAAAAAAAAAAAAAAARRRRRRRGGGHHHHHH!!!!