Displaying database info

[TheBlueRider]

I am a complete newb to mysql and php. I want to create a section in my webpage for displaying the next match for my team. I am presuming that i can enter all my fixtures into a database and enter a code that will dispay the next match info ie date and whom playing and the for it to automatically update after the match has been played and then display the next match.

Can you tell me if this is possible and how??

Thanks
BlueRider

[pete_bisby]

Create a table that will hold the list of fixtures. Date of match, team playing against, score, etc. E.g.:

CREATE TABLE `tblFixtures` (
`MatchID` INT( 12 ) NOT NULL AUTO_INCREMENT,
`DateMatch` DATE DEFAULT '0000-00-00' NOT NULL ,
`Opponent` VARCHAR( 50 ) ,
`Score` VARCHAR( 10 ) ,
PRIMARY KEY ( `MatchID` ) 
);

Then, create the query to bring up the next available match, in relation to today's date:

$qry = "SELECT * FROM tblFixtures WHERE DateMatch>=CURRENT_DATE() ORDER BY DateMatch LIMIT 0,1";

You must order the query by the date, to ensure the matches are displayed in order. The LIMIT 0,1 part of the query will display the results from row 0 (the first row of the result), and display only 1 row.

[TheBlueRider]

Thank for your help. I'll try it out

BlueRider