Won't display link

[adamjones]

Hi, I'm trying to display an iframe on my website, the source of which will depend on a link from the database. I'm using the GET method from the URL for the ID of the link, which is in the table;

 

<? include('core/dbconn.php');
$app = $_GET['id'];
$result="SELECT * FROM applications WHERE id ='$app'";
while ($row = mysql_fetch_array($result)) {

            echo $row ["link"];
   }
?>

 

I'm getting the following error;

 

The requested URL /<br /><b>Warning</b>: mysql_fetch_array() expects parameter 1 to be resource, string given in <b>/home/suvoocge/public_html/application.php</b> on line <b>34</b><br /> was not found on this server.

[JonnoTheDev]

You are missing the query function.

$result = mysql_query("SELECT * FROM applications WHERE id ='" . mysql_real_escape_string($app) . "'");

Edited January 24, 2013 by neil.johnson

[adamjones]

Whoops, thank you!