Display Based on Secondary Database Information Being Present or Not

[Sethm]

I have some code that is using a second database to store the image files for the particular listing in my database. What I am wondering is how to find out how to use an if statement on if there is anything pulled or not when I pull the information from it using the following code:

$sql = mysql_query("SELECT * FROM imagedb WHERE listingsid=$id");

 

I've tried the statement:

if ($sql != "") {
   echo "information";
}

 

It didn't work...

 

Could someone help point me in the right direction?

 

Thanks a lot!

[premiso]

I would suggest using mysql_num_rows

 

if (mysql_num_rows($sql) > 0) {
    //echo "information returned.";
}

 

Should work for you.

[Sethm]

Thank you SOO much for your quick response - saved my hair!