Database joins etc

[Siggles]

Hi,

 

I am creating a dbase that will allow the website I run to make predicitons on football games.

 

I have already created the users section and the tables which hold the games and the scores. I am now doing a seperate table for the predicitons from the users. I am trying to find out the best way to join the users tables and and the predicitions tables and also ways to get scores from the users predictions. In other words, results on the fly, or up to date tables/rankings for the users based on their predicitons.

 

Can anyone suggest a way to do this, maybe a tutorial on how to do table joins and how to display results(calculations from tables) on the fly?

 

Any help would be much appreciated.

 

Regards

 

Siggles

[Siggles]

These are the tables I have (amongst others)...

 

users

 

  username varchar(30)    - primary key       

  password varchar(32)             

  userid varchar(32) L               

  userlevel tinyint(1)         

  email varchar(50)             

  paidplayer smallint(6)           

  timestamp int(11) 

 

Fixtures

 

uniqueid - mediumint(    - Primary Key 

  gamenumber - char(2)           

  datecreated - date             

  datelastedited - datetime             

  dateplayed - datetime               

  opponent - varchar(20)             

  homeaway - varchar(5)               

  resultus - char(3)             

  resultthem - char(3)

 

Predicitions

 

  username - varchar(30)  - primary key (linking it to fixtures table)         

  uniqueid - mediumint(  - linking it to users table           

  prediction - char(1)             

  resultus - smallint(2)             

  resultthem - smallint(2)

 

[fenway]

There are a bunch of stickes that cover intro topics like joins.