Re: [PHP] function MAX with WHERE

2005-07-25 Thread Georgi Ivanov
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 = 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




 --
 Este mensaje ha sido analizado por MailScanner
 en busca de virus y otros contenidos peligrosos,
 y se considera que está limpio.

-- 
Regards
Georgi Ivanov

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] function MAX with WHERE

2005-07-24 Thread Jesús Alain Rodríguez Santos
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




-- 
Este mensaje ha sido analizado por MailScanner
en busca de virus y otros contenidos peligrosos,
y se considera que está limpio.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php