PHP Next Game

[thatboyjim]

Hi guys

I have a table within a mysql database which containes information about our games this season and generates our schedule.

What I'd like to do is have a box on our home page which shows our next game, but I've no idea where to start with it. Do i use the sql query to do it or PHP script?

And how would I do this?

Many thanks in advance.

James

[big_nerd]

thatboyjim,

Yes, you would use an SQL Query FROM php.

I would start by attempting to get the information...

$today = date("m/d/Y");
$query = "SELECT * from game_tbl WHERE game_date >= '$today' LIMIT 1";

game_tbl = your game game (as stored in your MySQL database)
game_date = The column that stores the game date.

If you post the code that you use to display the game info, I can help you further, if you need it.

good luck

[thatboyjim]

Thanks for your help...

I have managed to do it from that.

Cheers.

James

[big_nerd]

My Pleasure, anytime.