URL checking

[genista]

Hi all,

I have an $id that gets passed through the url, having messed around with it I have found that the script is not working, ie if it cannot find the enquiryid and the user together then it should return you to a suppliers page, any ideas on how to make this work?

if (isset($_GET['id'])) $id = intval($_GET['id']); 

$security= "suppliers.php";
$securityquery = "select enquiryid from enquiry where enquiryid= '$id' AND username= '$user'";
$securityresult=mysql_query($securityquery, $link) or die("MySQL query $securityquery failed.  Error if any: ".mysql_error());


if(empty($securityquery)) 
    { 

echo "<meta http-equiv='refresh' content='0;url=$security'>";
    }
    else{

Cheers,

G

[tron00]

You could count the number of rows returned by your query and then handle it appropriately.

if (isset($_GET['id'])) $id = intval($_GET['id']);

$security= "suppliers.php";
$securityquery = "select enquiryid from enquiry where enquiryid= '$id' AND username= '$user'";
$securityresult=mysql_query($securityquery, $link) or die("MySQL query $securityquery failed.  Error if any: ".mysql_error());
$securityResultCount = mysql_num_rows($securityresult);

if ($securityResultCount == 0) {
header ("Location: $security");
}