PHP/MySQL Help

[MacroGuru]

I am playing with the data exported from Stelmacks DB updater and I am working with the gameresults table

I have my query grabbing the data from this table and the teams table, but now I only want to display the most recent week on the site, I don't want to tie it down to the number, how would you go about doing this?

results.week = 6 right now, but I want it to show next weeks when it becomes 7

PHP/MySQL is not my strength.

[gstelmack]

cur_year = select year from gamedata

cur_week = select max(week) from results where year=cur_year

select * from results where year=cur_year and week=max_week

that's roughly what I do (although it's all ASP.NET / nHibernate for me)

[ShaneTheMaster]

I have stored procedures that pulls data out of Greg's database, such as Offensive stats, defensive stats, rookies, etc. that you can add to your database. Will that help? That way all you have to do is call the stored procs.

[MacroGuru]

I have stored procedures that pulls data out of Greg's database, such as Offensive stats, defensive stats, rookies, etc. that you can add to your database. Will that help?

That might help out bit.

[ShaneTheMaster]

That might help out bit.

PM me your email address, and ill send them as attachments.

[gstelmack]

You could just attach them straight in here, now that we're on Operation Sports.

[ShaneTheMaster]

Ok.. let's see.. here we go. Just remember to keep these backed up, because if you have to destroy your database, the procs go too! I learned my lesson. :)

[MacroGuru]

Ok.. let's see.. here we go. Just remember to keep these backed up, because if you have to destroy your database, the procs go too! I learned my lesson. :)

Thanks a bunch!

[cuervo72]

Hmm....I think I just rely on the week from gamedata.

[ShaneTheMaster]

Oh, yea.. forgot to mention.. these procs have 2 parameters, one for the year, and one for the week. If you pass in a 0 for the week, it gets the latest week for that year.