Re: Don't ejecute a sentence if a field is empty

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Jesús Alain Rodríguez Santos wrote:
Hello I'm new:
I need to know how can I stop a php sentence if my db is empty, for example
I have writed a php sentence, if every fields from mmy db are full, there
is no problem, but I delete every values from the all fields in my db when
I ejecute my script mysql give me an error, Ej:

$fecha = mysql_query("SELECT event_day, event_month, event_year FROM
$db_table WHERE event_title = $dia_maximo");
$fecha_max = mysql_fetch_array($fecha);
$fecha_maxima = $fecha_max['event_day'];
$diames_maximo = $fecha_max['event_month'];

wehen I ejecute the script the error message is it:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in /home/www/cfg/prueba/calendar_este2/index.php on line
277


$fecha = mysql_query("SELECT event_day, event_month, event_year FROM $db_table WHERE event_title = $dia_maximo");
if($fecha) {
	$fecha_max = mysql_fetch_array($fecha);

	$fecha_maxima = $fecha_max['event_day'];
	$diames_maximo = $fecha_max['event_month'];
} else {
	// No row returned...
}

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux