Help hiding some content when not enough records in query

I have a page using mysql_data_seek in order to return different records on different parts of the page.

I have it set to hide the first record where no records are in the query, but am having trouble getting it to hide content (non dynamic) where there are no records.

Link and details below...

link and details are missing

Hi Ray - you're too quick! While I was looking at it, I spotted something else, which I think I've now figured out what it was.

I'll post those details in a few minutes.

You can use this around the div:

<?php if ($row_rsProductUpdates) { ?>

That will prevent the entire row from showing if there is no data in the table after the data seek

Thanks Ray - will have a look.

If there are two sections:

One to show the most recent news item, i.e. the first record in the query, and
One to show the next three most recent news items, i.e. record 2, 3 and 4.

Then will that hide the non dynamic text from the space for records 3 and 4, if the query contains two records?

Yes it should work... just put the code around the entire <div> you don't want displayed... basically everything inside the current FOR loop.

Haven't got that - might have that in the wrong place.

Have attached an updated copy of the page below.

With that line added at line 193 and <?php } ?> at line 255 to close it.

I don't see the code I told you to add... it should be right after this:

<?php for($i=1;$i<=3;$i++) { ?> 

                        <?php  

                        mysql_data_seek($rsProductUpdates, $i); 

                        $row_rsProductUpdates = mysql_fetch_assoc($rsProductUpdates); 

                        ?>

<?php if ($row_rsProductUpdates) { ?>

and then close it right when you close the for loop like:

<hr>

                        

                

                          <?php } // I added this ?>

                          <?php } // Show if recordset empty ?>

Thanks Ray - I just had it around the next <div> up. That's working great now.