MYSQL query help

[wreed]

I am running this query and have problems...

SELECT * FROM weekly_rankings WHERE team = 'islanders' AND week = 3

But what I want to do is make it so I dont have to change the week area when I add a new week to the db, so in theory I want it to search the db and pull out the latest number in the week field, which it happens to be 3 right now, return that and the fields, rank, team, comment and record, but I seem to have a hard time using the MAX option.....any ideas? Here is a query that would work with SQL but not MYSQL....

select * from weekly_rankings where
team ='islanders' and week = (select max (week) from weekly_rakings)

[stolzyboy]

subqueries aren't available in mysql til version 4.2, which is in alpha version right now, you will just have to write the max query, set it to a variable, then use that variable in the second query, an easy way around subqueries, hurry up mysql dev's