Its Not Displaying The Data From Mysql

[madness69]

Hello there, im having some problem whit my php code, i cant display the data from my database, is there somethign missing or wrong?

 

Here is the code:

 

$con = mysql_connect("localhost","username","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
if(isset($_GET['id']))
{
$id=$_GET['id'];
mysql_select_db("db_name", $con);

$result = mysql_query("SELECT * FROM comments
WHERE article = '".$row['title']."' AND approved = 'YES'");

while($row = mysql_fetch_array($result))
{
echo $row['name'] . " " . $row['email'];
echo "<br />";
}
}

Edited December 13, 2012 by madness69

[Jessica]

See the post in my signature.

[madness69]

..., thanks anyway, bye

[Barand]

$result = mysql_query("SELECT * FROM comments

WHERE article = '".$row['title']."' AND approved = 'YES'");

$row has not yet been assigned a value

[Hall of Famer]

Yeah, sorta seems that way to me too, what is $row['title']? Perhaps you should use this instead:

 

$_GET['title']

 

Not sure if this helps though, it's difficult to help you unless we know what this $row['title'] is supposed to mean.