mysql_fetch_array() Troubles

[shimano55]

I have been having trouble getting one of my scripts to echo the contents of a field. Here is the coding. There hasnt been an error, but nothing shows on the page...just blank.

$query = mysql_query('SELECT add_to FROM add_db WHERE 1');

$row = mysql_fetch_array($query, MYSQL_BOTH);
 echo $row['0'];
?>

Thanks for any help that you can give,
shimano55

[hasin]

This should be

$query = mysql_query('SELECT add_to FROM add_db WHERE 1'); 

$row = mysql_fetch_array($query, MYSQL_BOTH); 
 echo $row[0]; //quotation has been removed

Thanks

[shimano55]

still displayed nothing....no error tho...Im beginning to think that it might be doing that because the field is empty...and that would mean that I am entering the value into the wrong text-box on phpmyadmin....so....

does anyone know where I am supposed to put this value?

Thanks,
shimano55

[lohmk]

i think something wrong with your sql command.
check whether if there's error in it
try this:

$query = mysql_query('SELECT add_to FROM add_db WHERE 1')
or die("Select error: ".mysql_error());

$row = mysql_fetch_array($query, MYSQL_BOTH);

echo $row[0]; //quotation has been removed

---

i have been very interested in your sql command.
what do u mean by ... WHERE 1???