Redirection Problem

[theimben]

On my MySQL search what I want to do is redirect a user to another page and show an error message if the search returned no results. But for some reason the user never gets redirected.

Can you spot my problem? :|

$sql = "SELECT * FROM `list` WHERE `title` LIKE '%".$search[0]."%' AND `url` LIKE '%".$sites[0]."%'";
		
$catcnt = mysql_fetch_row(mysql_query($sql));

if($catcnt[0] == ''){header('Location: index.php');}else{echo $catcnt[0];}

[chrishea]

If you search the forum first you can often find previous posts with similar problems. Try this one as an example:
http://www.daniweb.com/forums/thread101948.html

[somedude3488]

you don't echo a header redirect

[theimben]

Ooops. Thats a mistype. The problem still stands though. Ill update the code in the first thread.

[cwarn23]

Also it would probably be better to use strlen() or empty() to determine if there is no value to the array. Script should look like following:

$sql = "SELECT * FROM `list` WHERE `title` LIKE '%".$search[0]."%' AND `url` LIKE '%".$sites[0]."%'";
 
$catcnt = mysql_fetch_row(mysql_query($sql));
 
if(empty($catcnt[0]))
{ 
header('Location: index.php');
}
else{
echo $catcnt[0];
}

[theimben]

If you search the forum first you can often find previous posts with similar problems. Try this one as an example:
http://www.daniweb.com/forums/thread101948.html

Thanks for that...

I needed to use javascript for this. Heres my code now:

<?php
 if(empty($catcnt)){
echo("<script>location.href = 'index.php?error=Your search returned no results';</script>");
}else
{echo $catcnt[0];
} 
?>

[vinothkumarc]

$sql = "SELECT * FROM `list` WHERE `title` LIKE '%".$search[0]."%' AND `url` LIKE '%".$sites[0]."%'";
       
    $catcnt = mysql_fetch_row(mysql_query($sql));
         
    if(@!isset($catcnt[0]) && $catcnt[0]=='')
   {
         header('Location: index.php');
         exit;
   }
   else{
       echo $catcnt[0];
  }

-- Always use exit while using "header";