Re: Re: Don't ejecute a sentence if a field is empty
| From: | Burhan Khalid | Date: | Sun, 24 Jul 2005 06:35:29 +0000 |
| Subject: | Re: Re: Don't ejecute a sentence if a field is empty | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-219267@lists.php.net to get a copy of this message | ||
Jasper Bryant-Greene wrote:
Jesús Alain Rodríguez Santos wrote:This is very wrong. If $fecha is false, then it means that the query didn't execute properly, not that there were no rows returned. You should do this instead: $query = "SELECT event_day, event_month, event_year FROM $db_table "; $query .= "WHERE event_title = '".$dia_maximo; $fecha = mysql_query($query); if (!is_resource($fecha)) { die($query."<br />".mysql_error()); } // -- continue with the rest Also, make sure you have a valid connection to the database, mysql_error() will help you with sorting out what is the problem.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...}