Month events

[pavmoxo]

I have registers in a mysql DB and I want to show them for months. I think I have a var like this:

$id = "month(now())"; 
                $sql = "select * from agenda_geral where agenda='desporto' and month = ".$id." and area_ID = 1 order by day" ; 

But what I have to do for show the next or the previous month events in the same page without create a new??

[Twey]

Tried:

$sql = "select * from agenda_geral where agenda='desporto' and month = ".$id+1." and area_ID = 1 order by day" ;

?

[pavmoxo]

But how can I change the month with links?

Example:

<p><a href="agend_desporto.php??????"> Previous </a> | <a href="agend_desporto.php??????"> Next </a></p>

[Twey]

Ah, I see.

$modifier = isset($_GET['modifier']) ? mysql_real_escape_string($_GET['modifier'], $conn) : 0;
$sql = "select * from agenda_geral where agenda='desporto' and month = ".$id+$modifier." and area_ID = 1 order by day";

... where $conn is the resource handler for the connection to the database (the return value of mysql_connect or _pconnect).

[pavmoxo]

Sorry!! I don't understand!!!

What about the links?? What should I put for pass for the previous or for the next month like a calendar??

[Twey]

For a previous month:

agend_desporto.php?modifier=-1

For the next month:

agend_desporto.php?modifier=1

For a year ago:

agend_desporto.php?modifier=-12

For seven months from now:

agend_desporto.php?modifier=7

[pavmoxo]

$conn = mysql_connect(SERVER,DBUSER,DBPWD) or die ("Problemas na ligação MySQL");
                  $id = "month(now())";
                $modifier = isset($_GET['modifier']) ? mysql_real_escape_string($_GET['modifier'], $conn) : 0;
                $sql = "select * from agenda_geral where agenda='desporto' and month = ".($id+$modifier)." and area_ID = 1 order by day" ;
                    $queryl = query($sql) or die ("Query failed: " . mysql_error() . " Actual query: " . $sql);
                echo ($id + $modifier); 

The test echo below gives 1 when I click <a href="agend_desporto.php?modifier=1"> Previous </a> and -1 when I click <a href="agend_desporto.php?modifier=-1"> Previous </a>

Why doesn't gives the actual month minus or plus the modifier??

[pavmoxo]

It&#180;s fix.

But I have another question...how can I increment or decrement the var modifier for pass to others months like a calendar, when I click several times on a link?

[Twey]

That's impossible (or very difficult, at least). You'd have to modify the link.

[pavmoxo]

At this moment I have:

<p>
			  <a href="agend_desporto.php?modifier=-1"> Anterior </a> | 
			  <a href="agend_desporto.php?modifier=0"> Actual </a> | 
			  <a href="agend_desporto.php?modifier=1"> Seguinte </a>
		  </p>

And I tried to do with months:

<p>
			  <a href="agend_desporto.php?modifier=-3"> <? //echo trata_month($arrl["month"]-3) ?> </a><br />
			  <a href="agend_desporto.php?modifier=-2"> <? //echo trata_month($arrl["month"]-2) ?> </a><br />
			  <a href="agend_desporto.php?modifier=-1"> <? //echo trata_month($arrl["month"]-1) ?> </a><br /> 
			  <a href="agend_desporto.php?modifier=0"> <? //echo trata_month($arrl["month"]) ?> </a><br /> 
			  <a href="agend_desporto.php?modifier=1"> <? //echo trata_month($arrl["month"]+1) ?> </a>
		  </p>

function trata_month($data)
{
				 switch ($data){
							case 1:
								$data = "Janeiro"; 
							break;
							
							case 2:
								$data= "Fevereiro"; 
							break;
							
							case 3:
								$data = "Março"; 
							break;
							
							case 4:
								$data = "Abril"; 
							break;
							
							case 5:
								$data = "Maio"; 
							break;
							
							case 6:
								$data = "Junho"; 
							break;
							
							case 7:
								$data = "Julho"; 
							break;
							
							case 8:
								$data = "Agosto"; 
							break;
							
							case 9:
								$data = "Setembro"; 
							break;
							
							case 10:
								$data = "Outubro"; 
							break;
							
							case 11:
								$data = "Novembro"; 
							break;
							
							case 12:
								$data = "Dezembro"; 
							break;
						}
				 
				return $data;
}

When I do that some months modify or doesn't appear. Why?? What can I do correct this code?