[SOLVED] To how set something equal to the biggest number in a colum database?

[JJohnsenDK]

Hey

As the subject says; how do i set something equal to the biggest number in a colum database.

i have this database:

Seasons:
seasons_ID: 1 - year: 2006
seasons_ID: 2 - year: 2005
seasons_ID: 3 - year: 2007
seasons_ID: 4 - year: 2004

in a mysql_query how do i put year equal to the biggest number in year?

[i]$sql = "SELECT year FROM seasons WHERE year = what code here?";[/i]

[Caesar]

Do you mean something like...

[code]<?php

$db->query("SELECT max(year) FROM seasons");

?>[/code]

[JJohnsenDK]

i did  ;D thanks alot champ  :)