Need help with a simple select id please.

[11Tami]

Hi, I'm getting hung up here on what is I'm pretty sure is a simple id problem. Not sure why and really need some help. This is the only part I think that's causing the problem. I'm just trying to pull a row based on what id number it is.

 

$query = "SELECT comment FROM addthis WHERE `id` = '18'";

 

But here's the rest of the code if my code above looks ok, and maybe you can see where the problem following might be.

 

<?php 
$link = mysql_connect('severaddress', 'database', 'password'); 
if (!$link) { 
die('Not connected : ' . mysql_error()); 
} 

$db_selected = mysql_select_db('database', $link); 
if (!$db_selected) { 
die ('Can\'t use database : ' . mysql_error()); 
} 

$query = "SELECT comment FROM addthis WHERE `id` = '18'";

$result = mysql_query($query); 

while ($row = mysql_fetch_array($result)) 

{
echo "$row[comment]"; 
} 

?>

 

$result says it is putting the query in the variable $result.

while says "while $row has found a result put it in the echo."

 

Hope someone can help, thanks.

[emehrkay]

i dont see any errors that stand out, try adding this to output the error

 

$result = mysql_query($query) or die(mysql_error()."<br />".$query);

[11Tami]

Doh! I'm an idiot. I pulled a row that wasn't there! lol. Thanks for the extra error message.