Quoting Post Archived Topic: It will not be bumped to the top of the forum. Topic [php] if a database entry does not exist Membername   Not a member? Sign Up Free (takes 20 seconds) Password   Forgotten your password? Post Font: Verdana Arial Black Georgia Comic Sans Impact   Size: Tiny Normal Big Huge   Color: Default Dark Red Red Orange Brown Green Olive Cyan Blue Dark Blue Indigo Black [ Check Spelling ] [ Post Preview ] [ LiveTags ] Quote: from [m]Bestm8ts[/m] at 7:20 am on Feb. 12, 2007[quote]getting pageID [code] $pageid = $_GET['id']; if($pageid == '') {$pageid = 'home';} [/code] Database connection [code] include ('db_connect.php'); $query = "SELECT * FROM pages WHERE id='".$pageid."'"; $result = mysql_query($query); $num = mysql_numrows($result); mysql_close(); [/code] ok so the above code gets a page id from the url and uses that to get info from a database.. ive included an if statement to account for times when people go to the base dir without the tag call.. what i want to be able to do is create an statement to account for times when people put in an invalid pageid, the code would look in the database and obvously if the pageID is wrong nothing will come back, i wana write something that states if database call is false post a code which will display a 404 error.. if (database = "") {$pageid = 'error'}; the if 'database' is just to illustrate the point.. anyone know how to check if a databse call is false? [/quote] FAQ Keyword Search: Post Options Favorites Manager Notify me of new replies to this topic by email Notify me of new replies to this topic by private message Original Post Bestm8ts Posted at 7:20 am on Feb. 12, 2007 getting pageID Code: $pageid = $_GET['id']; if($pageid == '') {$pageid = 'home';} Database connection Code: include ('db_connect.php'); $query = "SELECT * FROM pages WHERE id='".$pageid."'"; $result = mysql_query($query); $num = mysql_numrows($result); mysql_close(); ok so the above code gets a page id from the url and uses that to get info from a database.. ive included an if statement to account for times when people go to the base dir without the tag call.. what i want to be able to do is create an statement to account for times when people put in an invalid pageid, the code would look in the database and obvously if the pageID is wrong nothing will come back, i wana write something that states if database call is false post a code which will display a 404 error.. if (database = "") {$pageid = 'error'}; the if 'database' is just to illustrate the point.. anyone know how to check if a databse call is false?

Replies Bestm8ts Posted at 7:20 am on Feb. 12, 2007 getting pageID Code: $pageid = $_GET['id']; if($pageid == '') {$pageid = 'home';} Database connection Code: include ('db_connect.php'); $query = "SELECT * FROM pages WHERE id='".$pageid."'"; $result = mysql_query($query); $num = mysql_numrows($result); mysql_close(); ok so the above code gets a page id from the url and uses that to get info from a database.. ive included an if statement to account for times when people go to the base dir without the tag call.. what i want to be able to do is create an statement to account for times when people put in an invalid pageid, the code would look in the database and obvously if the pageID is wrong nothing will come back, i wana write something that states if database call is false post a code which will display a 404 error.. if (database = "") {$pageid = 'error'}; the if 'database' is just to illustrate the point.. anyone know how to check if a databse call is false? All 6 previous replies displayed.