[Resolved] This one should be easy...

[kwmumonkey]

This should be easy...

I cant' get the echo part of the if statement not to print if the query results are empty... should I be comparing it to something else other than ""? What is in a query if there are no results to return?

$selectfollowup = "SELECT * FROM followup WHERE showid = $showid";

$followup = mysql_query($selectfollowup);

if ($followup != "") {

echo ("<p><font face=Verdana, Arial, Helvetica, sans-serif><b><font size=-1>Related Information</font>
<br>
<img src=../../../pic/hrblue.gif width=300 height=1 align=absbottom></b></font></p>");

}

Then put the query results into variables and echo them out.

If $followup is empty, then do nothing.

This should be really easy, but I'm stuck... any help would be appreciated.😃

[stolzyboy]

if (mysql_num_rows($followup) != 0)
{
//do results of query
}
else
{
echo "there are no results";
}

[kwmumonkey]

I told you it would be easy!!!!!

Dumb... I racked my brain on that one for a while... thank you so much!!!!!

Works like a charm!!!