Re: [PHP] function MAX with WHERE

What print_r($test_m) say ? Or echo mysql_num_rows($test); May be you get 0 records from your query. On Monday 25 July 2005 09:06, Jesús Alain Rodríguez Santos wrote: I have someting like this: $test = mysql_query(SELECT MAX(dato) AS datos FROM tabla WHERE campo_mes = '$mes'); $test_m =

[PHP] function MAX with WHERE

I have someting like this: $test = mysql_query(SELECT MAX(dato) AS datos FROM tabla WHERE campo_mes = '$mes'); $test_m = mysql_fetch_array($test); $test_mes = $test_m['datos']; print $test_mes where $mes is a value I need to know if something its wrong, because I don't recive any error, but I