Get ID error catching

[markspec87]

ive got a page where i use this code to display data from my database.

[code]$query="SELECT * FROM results WHERE autonumber = $_GET[id]";[/code]

When they goto the index page and click a result it would goto "results.php?id=1/2/3/"

And display the appropiate data.

My question is, how can i get the page to display "No data specified" or something similar when someone just types results.php with no ID. At the moment it will just show the page with the database driven areas blank.

thanks :)

[hostfreak]

Try:

[code]
if ($id == "") {
echo "No data specified<br>";
}
else {
//other code
}
[/code]

[desithugg]

[code]
<?
$id = $_GET[id];
if ($id == "") {
echo "No data specified";
}
?>
[/code]
same thing as above but the person forgot to set the $id variable

[hostfreak]

Oops, good catch.

[wildteen88]

This is better, added a bit of data validation.
[code=php:0]if(empty($_GET['id']) || !is_numeric($_GET['id']))
{
  echo "The data provide is either invalid or was not specified.";
}[/code]