title: Having trouble displaying data from the database to my website
body: <p>I have come across a problem when i try to display data from my database now I have never had this problem before and it will not show me any errors! can anyone see the problem with this? Any and all help is appreciated.</p>
  
  <pre><code>&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;
  &lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;
  &lt;head&gt;
  &lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8" /&gt;
  &lt;link rel="stylesheet" type="text/css" href="Styles.css"/&gt;
  &lt;?php
      error_reporting(E_ALL);
      $pagename=$_GET['Recipe'];
      $recipeID=$_GET['id'];
  ?&gt;
  &lt;title&gt;&lt;?php echo"$pagename"?&gt;&lt;/title&gt;
  &lt;/head&gt;
  &lt;body&gt;
  &lt;?php
      $mySqlHost='localhost';
      $mySqlUsername='';
      $mySqlPassword='';
      $mySqlDatabase='';
      $mySqlConnect=mysql_connect($mySqlHost,$mySqlUsername,$mySqlPassword) or die("Error Connecting to Database");
      mysql_select_db($mySqlDatabase,$mySqlConnect) or die ("Could not Select Database".mysql_error());
  
      $selectRecipeQuery="SELECT recipe_name,food_type_english FROM recipe WHERE recipe_id='$pagename'";
      $result=mysql_query($selectRecipeQuery) or die ("could not select data from table".mysql_error());
  
  $tableRow=mysql_fetch_array($result);
          $recipe_name=$tableRow['recipe_name'];
          $food_type_english=$tableRow['recipe'];
  
  
      echo "&lt;p&gt;$recipe_name&lt;/p&gt;";
      echo "&lt;p&gt;$food_type_english&lt;/p&gt;";
  ?&gt;
  &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>
  
  <p>Please take a look to see if you can find out why it is not letting me display the data</p>