month events...

[pavmoxo]

If I have:

...
$sql = "select * from agenda_geral where agenda='desporto' and Bmonth = (month(now())+1) + ".$modifier." and area_ID = 1 order by Bday" ;
                    $queryl = query($sql) or die ("Query failed: " . mysql_error() . " Actual query: " . $sql);
                  $contal = mysql_num_rows($queryl);
               
                
            for ($j=0; $j<1;$j++)
            {
                $arrl = mysql_fetch_array($queryl);... 

and I want if there aren't no events in the next month the link not appears. What should I do in the next code?

<? if( $arrl["Bmonth"] == NULL) {?>
                            <a></a>
                      <? } else { ?>
                              | <a href="agend_desporto.php?modifier=1"> Seguinte </a> 
                      <? } ?>

[cybercoder]

Well you would not test for a NULL value:

<? if( $arrl["Bmonth"] == NULL) {?>

You would test for nothing...But all we need to do is test for the true value, a month:

<? if( $arrl["Bmonth"] ) {?>
| <a href="agend_desporto.php?modifier=1"> Seguinte </a>
<?php
}

Have fun

[pavmoxo]

But i don't understand what it's happen!!

Bmonth = month(now()) in my querie but I wan't to verify if exists a register in the next month in DB for show the word "Seguinte". I don´t know what to do more.

Code:

<?
                  <?
                  $conn = mysql_connect(SERVER,DBUSER,DBPWD) or die ("Problemas na ligação MySQL");
                mysql_select_db (DB);
                $modifier = isset($_GET['modifier']) ? mysql_real_escape_string($_GET['modifier'], $conn) : 0;
                $day = date(d);
                if($day < 25)
                        $sql = "select * from agenda_geral where agenda='desporto' and Bmonth = month(now()) + ".$modifier." and area_ID = 1 order by Bday" ;
                else
                        $sql = "select * from agenda_geral where agenda='desporto' and Bmonth = (month(now())+1) + ".$modifier." and area_ID = 1 order by Bday" ;
                    $queryl = query($sql) or die ("Query failed: " . mysql_error() . " Actual query: " . $sql);
                  $contal = mysql_num_rows($queryl);
               
                
            for ($j=0; $j<1;$j++)
            {
                $arrl = mysql_fetch_array($queryl);
            ?>            
       <h1>Desporto - <? echo trata_month($arrl["Bmonth"])." de ".$arrl["Byear"]; ?></h1>
       
       
       <!-- ALTERNATIVA-->
          <p>
                <? if($modifier == -1) {?>
                      <a href="agend_desporto.php?modifier=0"> Actual </a> 
                    <?
                         $next_month= $arrl["Bmonth"];
                       echo $next_month;
                       
                       if($arrl["Bmonth"]) {?>
                            | <a href="agend_desporto.php?modifier=1"> Seguinte </a> 
                      <? } ?>
                              
                    
              <? 
              } 
              elseif($modifier == 0) 
              {
              ?>
                      <a href="agend_desporto.php?modifier=-1"> Anterior </a> | 
                      <a href="agend_desporto.php?modifier=0"> Actual </a> 
                      <?
                       $next_month= $arrl["Bmonth"];
                       echo $next_month;
                       if($arrl["Bmonth"]) {?>
                            | <a href="agend_desporto.php?modifier=1"> Seguinte </a> 
                      <? } ?>
              <? }
              elseif($modifier == 1)
              {
              ?>
                    <a href="agend_desporto.php?modifier=-1"> Anterior </a> | 
                  <a href="agend_desporto.php?modifier=0"> Actual </a> 
              <? } ?>
              
              
          </p>
          <? } ?>