Re: function MAX with WHERE
| From: | Mark Rees | Date: | Mon, 25 Jul 2005 08:59:09 +0000 |
| Subject: | Re: function MAX with WHERE | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-219289@lists.php.net to get a copy of this message | ||
"Jesús Alain Rodríguez Santos" <wmaster@cfg.jovenclub.cu> wrote in message
news:2103.192.168.6.61.1122271572.squirrel@correo.cfg.jovenclub.cu...
> 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 see nothing
Try this, it will tell you if something is wrong
echo mysql_error();
If nothing is wrong, then perhaps your query returns no rows? Test this by
removing the where clause (assuming there is some data in tabla).