If..Else Result

[cdtc]

I am sure it is a simple answer, but in a IF..Else Statement how do I redirect to a one page if there is a result from my database or redirect to another if there is no result?

[brown2005]

if($result = 1)
{
header("location: http://gotopage.com");
}
else
{
header("location: http://gotopage2.com");
}

[brown2005]

using that

if use post your SELECT STATEMENT I CAN WRITE IT PROPER...

[GingerRobot]

yes, it might vary slightly depending on what you are retrieving from the database.

[cdtc]

$strSQL="SELECT * FROM School WHERE ([School Code Number] = '" .$_POST['schoolcode']."')";

[brown2005]

$strSQL="SELECT * FROM School WHERE ([School Code Number] = '" .$_POST['schoolcode']."')";
$strRows = mysql_num_rows($strSQL);

if ($strRows  > 0)
{
header("location: http://gotopage.com");
}
else
{
header("location: http://gotopage1.com");
}

i think

[cdtc]

Thats Great thanks!!

(look out for www.creaseyIT.co.uk launch date sept 1st)