Hi there,

I'd like to do the following so that if no ID or an incorrect one is specified, then alternative pages are shown.

If database entry = present, include file.php, if database entry = non existent, include otherfile.php but if no id requested, include thisfile.php.

The database entry would need to be found via a variable defined by the URL. I have this code- thanks to members here. If the ID requested from the URL is not present in the database, I'd like it to include another file and if no ID is requested, then request another page. If an ID is found, then it includes another.

How might I do this?

Thanks

Sam

hi dear, i read ur problem , ur problem soluation is that when u r checking on the database for a particuallar page then make a if conditon that if condtion

e.g

if($ID==Null){
redirect to page0
}
else if $ID==$row1->ID){
redirec to page1
}
else{
msg=wrong id
or redirect another page
}

Thanks! I used the top one which is great but the second one needs to be able to find out from the database whether that ID exists and if not, then it should display a certain page. From what I can see, else if $ID==$row1->ID will only work if one ID equals another, not check if it exists.

Any help is appreciated.

if($ID==Null) could be if($ID)

for the second question.

PHP Code:

$sql= "SELECT * FROM `yourtablehere` WHERE id=$ID";
$query = mysql_query($sql);
$totalRows_Rec = mysql_num_rows($query);
if($totalRows_Rec>0){
include this.php;
} else {
include that.php;
}