Need alittle help here

[sks1024]

I have a message board set up that has a field that stores paths to images that users have posted along with there message. I want to query the db to look for the last post that has a photo path in it.

IE.
Select fldphoto from tablename where last post with a path in this field is Not NULL

I have the logic but dont really know how to set up the query.

thanks,
Stan

[abnfire]

select *
from table
where path is not null
order by path_id DESC

[sks1024]

Thanks I got it but a little more in detail

$Host = "localhost";
$User = "username";
$Password = "password";
$DBName = "dbame";
$TableName = "tablename";


$Link = mysql_connect($Host, $User, $Password) or die ("The database connection could not be established!");	
$query = "SELECT id,fldphoto from $TableName where fldphoto != 'NULL' ORDER BY id DESC";
$result = mysql_db_query($DBName, $query, $Link) or die("Could not complete database query");

$row = mysql_fetch_array($result);
$photo_name = array_pop($row);

print"<img src=$photo_name>";