Can't display/echo from db

[kclark]

I am getting this error:

Parse error: syntax error, unexpected T_STRING in /usr/local/4admin/apache/vhosts/ladysfuneralhome.com/httpdocs/photos/pics.php on line 9

<?PHP 

  $db_name = "table";

  $link = mysql_connect("localhost", "username", "password") or die("Could not connect to server!");
  $db = mysql_select_db($db_name, $link) or die("Could not select database!");
  $query = "Select * from photos where ID = '" . $_Request['ID'] . "';

  echo ("caption");
?>

[rincewind456]

<?PHP 

  $db_name = "table";

  $link = mysql_connect("localhost", "username", "password") or die("Could not connect to server!");
  $db = mysql_select_db($db_name, $link) or die("Could not select database!");
  $query = "Select * from photos where ID = '" . $_Request['ID'] . "'";   //<----Missing " here.

  echo ("caption");
?>

[kclark]

THanks, that did away with the error, but now I just have a black screen.

[Piranha]

Can't you even see "caption"? It should be visible. You can also try to echo the $query and see if it looks right or not.

I think you need to type $REQUEST['ID'], it will only work with all caps. But you should use $GET or $POST instead since it's not possible to use $REQUEST everywhere. And you should be sure to escape everything you add in a SQL statement.

[kclark]

If I use

echo ("ID"); 

instead of

echo ("caption"); 

it will work