[Resolved] dropdownlist with variable months

paulus4605

thanks to tommynanda I figured out what to do with the date problem.
is there a way to use this function strtoupper (date("MY", mktime(0,0,0,Date("m")-1,1,Date("Y"))));

(I adapted the function a little bit)
in a dropdownlist and what do I have to do to adapt the several files where I'm depending on the value of this function

strtoupper (date("MY", mktime(0,0,0,Date("m")-1,1,Date("Y"))));

the result of this function is JUN2004

the most Ideal solution is that I select the month "example june 2004" (on my userinterface) and that I get all the data concerning june 2004 without modifying each file seperatly
with the exeption when a new month is ready ofcourse

thanks again for your time and feedback

Paul

tommynanda

I didnt get ur Q well, but I guess u are asking about $GET and $POST rite? okay lets go thru a example

userinterface.php

<?
$idate = strtoupper (date("MY", mktime(0,0,0,Date("m")-1,1,Date("Y")))); 
?>
<form action="selectdata.php" method="POST">
<select name="month">
<option value="<? echo $idate; ?>">
.... <? // More Options ?>
...
</select>
<input type=submit>
</form>

selectdata.php

$month = $_POST['month'];

$query = "SELECT * FROM table WHERE month = '$month'"; // If its a DB

Is this wat you looking for? If not.. be more detailed

Have Fun!
TommYNandA

paulus4605

Tommy I will post the content of the userinterface in which I want to have a dropdownlist and I will post also the content of a file in which the date should be adapted aswell

this is the user interface

<HTML>
<head>
<title>[EasyPHP] - Web Local</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
a:link { font-weight:bold; color:Silver; text-decoration:none }
a:visited { font-weight:bold; color:Silver; text-decoration:none }
a:hover { font-weight:bold; color:White; text-decoration:none }
a:active { font-weight:bold; color:#E00E00; text-decoration:none }
a:focus { font-weight:bold; color:#00E000; text-decoration:none }
.text1 {font-family: Arial, Helvetica, sans-serif;font-size: 11px;color: White;text-align : center;}
.text2 {font-family: Arial, Helvetica, sans-serif;font-size: 11px;color: Silver;text-align : left;}
.titre1 {font-family: Arial, Helvetica, sans-serif;font-size: 12px;font-weight: bold;color: #FFFFFF;}
.titre2 {font-family: Arial, Helvetica, sans-serif;font-size: 12px;font-weight: bold;color: #cccccc;}
</style>
</head>

        Electronic Rem Note version 1.00
      </TD>
    </TR>
  <TR VALIGN="MIDDLE">
    <TD ALIGN="CENTER" class=text1>
      [ <A HREF='create_data_base.php' class=text2> Créer la base de donnée </A> ] <BR> <BR>

      [ <A HREF='test.php' class=text2> Charger resultats de la rem </A> ] <BR> <BR>
      [ <A HREF='frame.php?Dealer_Rem=INDEP.00001.01186' class=text2> Recap dealer rem <A> ] <BR> <BR>
      [ <A HREF='list.php' class=text2> Dealer Liste </A> ]

      <p>[ <A HREF='index_annex.html' class=text2> ANNEX <A> ] <BR> <BR>

    </TD>
    <TR>
      <TD class=text1>
        This site has been realized by Paul
      </TD>
    </TR>
  </TR>

</BODY>
</HTML>

and one of the files that should be adapted is

<?
include "datas/connection_data.php";
include "datas/connect.php";

$Dblnk=connect ();

if (isset($HTTP_GET_VARS)){
while(list($name, $value) = each($HTTP_GET_VARS)){
$$name = $value;
}
}

if (!isset($Dealer_Rem)) $Dealer_Rem = 'INDEP.00001.01186';
if (!isset($Counter)) $Counter=0;

$Current_Month = strtoupper (date("MY", mktime(0,0,0,Date("m")-2,1,Date("Y"))));

if (!isset($Dealer_Pos))
{
include "datas/annex1.php";
$Dealer_Pos = '';
}
else
{
include "datas/annex1_Pos.php";
}

$Line1 = "";
$Line2 = "";
$Line3 = "";
$Line4 = "";
$Line5 = "";
$Line6 = "";
$Line7 = "";

if ($res=send_sql($Data_Base, $Query_annex1))
{
$Tot_Lines = mysql_num_rows($res);
while ($row = mysql_fetch_row ($res))
{
$Line1 = $Line1.$row[0]." <BR>";
$Line3 = $Line3.$row[2]." <BR>";
$Line4 = $Line4.$row[3]." <BR>";
$Line5 = $Line5.$row[4]." <BR>";
$Line6 = $Line6.$row[5]." <BR>";
$Line7 = $Line7.$row[6]." <BR>";
}

echo "<A NAME='Annex1'></A>";

echo "<CENTER> <TABLE WIDTH='800' CELLSPACING='0' CELLPADDING='0'> <TR> <TD> <TABLE BORDER='1' WIDTH='150' class='text1'> <TR> <TD> Annex1 </TD> </TR> </TABLE> </TD> </TR> </TABLE> </CENTER> <BR>";

echo "<CENTER> <TABLE BORDER = '1' class='text1'>";
echo " <TR> <TD COLSPAN='7'> (a) Annex 1 : Overzicht van al uw geremunereerde kaarten/diensten </TD> </TR> <TR> <TD> Verkooppunt</TD> <TD> simkaart </TD> <TD> klant </TD> <TD> Activatiedatum </TD> <TD> tariefplan/dienst </TD> <TD> vergoeding </TD> </TR>";
echo "<TD> ".$Line1." </TD>";
echo "<TD> ".$Line3." </TD>";
echo "<TD> ".$Line4." </TD>";
echo "<TD> ".$Line5." </TD>";
echo "<TD> ".$Line6." </TD>";
echo "<TD> ".$Line7." </TD>";
echo "</TR> </TABLE>";
echo "<BR>";
if ($Counter>0)
{
$CounterPrec = $Counter - 50;
if (!$Dealer_Pos)
{ echo "<A HREF='annex1.php?Dealer_Rem=".$Dealer_Rem."&Counter=".$CounterPrec."'> [ Previous Page ] </A>"; }
else
{ echo "<A HREF='annex1.php?Dealer_Rem=".$Dealer_Rem."&Dealer_Pos=".$Dealer_Pos."&Counter=".$CounterPrec."'> [ Page précédente ] </A>"; }
}

echo "<A HREF='index_Annex.php?Dealer_Rem=".$Dealer_Rem."&Dealer_Pos=".$Dealer_Pos."'> [ back to annex menu ] </A>";

if ($Tot_Lines==50)
{
$Counter += 50;
if (!$Dealer_Pos)
{ echo "<A HREF='annex1.php?Dealer_Rem=".$Dealer_Rem."&Counter=".$Counter."'> [ Next page] </A>"; }
else
{ echo "<A HREF='annex1.php?Dealer_Rem=".$Dealer_Rem."&Dealer_Pos=".$Dealer_Pos."&Counter=".$Counter."'> [ Page suivante ] </A>"; }

}

thanks again for the help

tommynanda

wat are the options in drop down list? different months? like
JAN2004, FEB2004, MAR2004 etc., ? if yes how many months? and wats in $Query_annex1? is your Querry depending on the variable $Current_Month?

paulus4605

yes the different month from jan2004 till dec2004 the query itself is not depending on the variable in this query you find all the queries I need to build up annex1

thnaks again

tommynanda

Add this to your user interface

<form action="adaptablepage.php" method="POST"> 
<select name="month"> 
<? 
for($i=-7;$<=5;$i++)
{
$idate = strtoupper (date("MY", mktime(0,0,0,Date("m")+$i,1,Date("Y"))));  

echo "<option value='$idate'> ";
}
?> 
</select> 
<input type=submit> 
</form>

replace this in your adaptable page
$Current_Month = strtoupper (date("MY", mktime(0,0,0,Date("m")-2,1,Date("Y"))));

$Curren_Month = $_POST['month'];

Although, this is not a best logic... this would work

TommYNandA

paulus4605

Tommy I'm still confused here
when I try to do this I get the dropdown menu without any data.
in the userinterface = indexpage I entered the formule you mentioned in your previous reply and after modifying it to make sure I have the right formule I changed adaptable page in annex.php
in which I just changed the
$current_month = 'MAY2004' into $_POST['month'];

I now get several error messages when trying this out

perhaps I need to look at it from a different angle and try to figure out a way in which I see a dropdownmenu on my index page where after I select a month the dates are automaticly adapted in the 9 different files that need to be altered.

is this possible in the buildup that I'm using right now or do you think there is another solution for this problem?

thanks again for your time and feedback

Paul

tommynanda

I cant really know your problem... coz its too much to guess from too many includes that you have... anyway try this code...

Add this in your user Interface

<form action="adaptablepage.php" method="POST">
<select name="month">
<?
for($i=-6;$i<=5;$i++)
{
$idate = strtoupper (date("MY", mktime(0,0,0,Date("m")+$i,1,Date("Y"))));
echo "<option value='$idate'>$idate";
}
?>
</select>
<input type=submit>
</form>

In your annex.php

replace

$Current_Month = strtoupper (date("MY", mktime(0,0,0,Date("m")-2,1,Date("Y"))));

with

$Curren_Month = $_POST['month'];

paulus4605

Tommy
I tried that but it still won't work
the includes that you see contains only the queries that I need to get all the info that I need based on HQ's and stores related to that HQ

is there a way that I create a dropdown list in which I try the following
<div class="smallfont" style="text-align:left; white-space:nowrap">
<form action="forumdisplay.php" method="get">
<input type="hidden" name="s" value="" />
<input type="hidden" name="daysprune" value="30" />
<strong>Forum Jump</strong><br />
<select name="f" onchange="this.form.submit();">
<optgroup label="Site Areas">

		<option value="-1" >Please select one</option>
		<option value="JAN2004" >strtoupper (date("MY", mktime(0,0,0,Date("m")-1,1,Date("Y"))));</option>

the only thing I don't know how to adapt the files that needs to be adapted each month?

thanks again for all your help and feedback

paulus4605

I will close this thread since I didn''t get any feedback after a whole week