just show text if certain variable is filled with content

delray

hi!

I've troubles with showing a text/button just when a certain vairable is filled with content.
this means in the middle of my doc I read just 1 entry from the db which consists of 10 fields (like ..., page1, page2, ..., page8).
the content of each of these page fields is shown on the same file, by count up the variable $page.
at the bottom fo my doc I want to build a function which shows NEXT and PREVIOUS buttons just when the variable to be shown on the 'next' page contains any text. if it's empty the buttons should not appear.

the following script is the script the works perfect, but it's too 'static', because if for example the variable page8 is empty and I'm on page 7 the NEXT button shouldn't appear...

<?
if ($page!=8) {
?>
<td width="90"><a href="<? echo 'cv.php?page='.($page+1); ?>"
onmouseover="roll('nex',b8o)"
onmouseout="roll('nex',b8)" onFocus="this.blur()"><img src="../images/next.gif" width="88" height="14" border="0" name="nex"></a></td>
<? }

if I complete the function it doesn't work anymore!

<?
if (($page==1) && ($page2!=0)) {
?>
...

any ideas????

GBahle

I assume you got the values you retrieved form the database in an array $results and that your current page nr is stored in $page.

Then the check should be sth like

if ($results[$page+1] <> "") {
    // your print next button code here
}

Hope that helps. The trick is to check the actual content of the next page, not juggle around with the page numbers alone.
If you dont retrieve all the database entries at once (which could be a good or bad idea, depending on their size and whether you plan to use sessions to store them between page calls), you would possibly have to retrieve at least the current value, the previous value (for the "previous" button should you want one) and the next value.