Re: [PHP] redirect if sql = nothing

[Website4S]

In a message dated 20/02/2001 16:42:51 GMT Standard Time, 
[EMAIL PROTECTED] writes:

<< $sql = "select * from table where bla bla bla";
 
 if(!isset($sql)) {
    do this;
 } else {
    do this;
 }
 
 I think.... ?
 
 -Brian >>

This way might be a little easier

$sql = "select * from table where bla bla bla";
$num_rows = mysql_num_rows($sql);

if ($num_rows==0){
header ("Location: Http://www.YOURURL.com/");
}

Although depending on the rest of your script the header may have already 
been sent in which case it won`t work. 

HTH
Ade

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]