RE: [PHP-DB] empty set query

2005-02-08 Thread Bastien Koert
Every var should be set at the beggining of the script $title = ''; $director = ''; then if there is no result, already has a value bastien From: J. Connolly [EMAIL PROTECTED] To: PHP list php-db@lists.php.net Subject: [PHP-DB] empty set query Date: Tue, 08 Feb 2005 13:22:56 -0500 I have a query

RE: [PHP-DB] empty set query

2005-02-08 Thread Hutchins, Richard
Many ways to remove the epidermis from a feline, but... You may want to do something equivalent (I think you're using mysqlite) to the mysql_num_rows() function on your result set as a condition to running your while loop . In pseudocode... if(mysql_num_rows($result_set) 1){ echo out

Re: [PHP-DB] empty set query

2005-02-08 Thread J. Connolly
Thanks to you both Richard and Bastian. I am a newb and am trying to work alot out for myself. I decided to use the number rows method and validate against that. But now that I know that I should be defining my variables at the top, that will help alot. jzf Hutchins, Richard wrote: Many ways