[SOLVED] Query returns nothing.

[StanLytle]

This looks simple, but it doesn't work.  I get no output what so ever, not even an error message.  The page does connect to the database, I've tried existing queries that do work.  $NewPhotoID is valid, it contains a value, I've checked.  Field names and table name are correct and spelled correctly.

 

$sql = "SELECT FileName FROM Photos WHERE PhotoID = $NewPhotoID";

$result = mysql_query ($sql);

print $FileName;

 

My server is running:

php version 5.2.6

mysql version 5.0.51a-community

[corbin]

http://php.net/mysql_fetch_assoc

[StanLytle]

Thanks.  I didn't know it would have to be output as an array.