Posted by "Richard Lynch" on 07/25/05 04:20

On Sat, July 23, 2005 2:18 pm, Jesús Alain Rodríguez Santos said:
> 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

After adding the error checking with mysql_error() others have suggested,
the error message you get will, most likely, comlpain that there is no
field named 'XYZ' where XYZ is your $dia_maximo

That's because you need to put apostrophes around text data in SQL.

".. WHERE event.title = '$dia_maximo' ";

--
Like Music?
http://l-i-e.com/artists.htm

[Back to original message]