RE: [PHP] test for empty $result??
| From: | Jeff Lewis | Date: | Mon, 10 Sep 2001 17:42:52 +0000 |
| Subject: | RE: [PHP] test for empty $result?? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-66789@lists.php.net to get a copy of this message | ||
Just use:
if (!$result){
code here
}
Jeff
> -----Original Message-----
> From: Andrew [mailto:andrew@salamander.net]
> Sent: Monday, September 10, 2001 1:34 PM
> To: php-general@lists.php.net
> Subject: [PHP] test for empty $result??
>
>
> I know that this has been discussed before, but I cannot find the threads
> so...
>
> I have a function that does a mysql_query and want to break if
> the SQL query
> didn't return any rows in $result.
>
> empty(), isset() will not work, for obvious reasons.
>
> Can anyone suggest an alternative?
>
> $sql="select row from table where field = \"1\"";
> $link_id = mysql_connect($hostname, $username, $password);
> mysql_select_db($database, $link_id);
> $result = mysql_query ($sql, $link_id) or die;
>
> //this doesn't work...right?
> if (empty($result)) break;
>
> best,
> andrew
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
>