What I am trying to do is:
Question #1
What I want it to do:
When submitted the page will show a "iframe". And a different one depending on what value $_POST[lista] is.
Problem:
When selecting 5 and press submit-button right iframe will appear.
When selecting 10 and pressing submit-button AFTER above will generate right value but wrong iframe (just like it's cached or something?)
Question #2
What I want it to do:
When selecting year, month and day and "lista"-value then pressing submit I want it to search trough mysql showing up results starting on the selected year, month, day
and show selected value from "lista" as a result-number (select year2006, month10, day06, lista10) will then show up a list of mysql-info where the first row starts with the selected month and the 9 rows after that. Just like (this doesn't work) SELECT MAX(datum=20061006) SORT BY DESC LIMIT 10 ... Hope you understand... :/
Solution:
?
<?php if(empty($_COOKIE[username])) { ?><script type="text/javascript">self.location.href="../../index.php"</script><? } ?>
<?php $list = $_POST['list']; ?>
<HEAD>
</HEAD>
<?php if($_POST[resub]=="yes") { echo '<SCRIPT language="JavaScript">document.myform.submit();</SCRIPT>'; } ?>
<table><td valign="top">
<?php
if(!empty($_POST[lista])) {
include 'db.php';
mysql_connect ($Host, $User, $Password);
mysql_select_db($DBName);
$query = "SELECT DISTINCT (datum), username FROM diabyte_db WHERE username='$_COOKIE[username]' ORDER BY datum DESC LIMIT $_POST[lista]";
$result = mysql_query($query) or die(mysql_error());}
echo "<form method='post' name='myform' action='db_exp.php'>"; ?><div style=" overflow:hidden; width: 81px; height: 181px;"><?php echo "<Select name='list[]' MULTIPLE size='0'>";
for ($i = 0; $i <= 14; $i++) {
while ($row = mysql_fetch_array($result)) {
echo "<OPTION selected type='hidden' name='d".$i++."' value='".$row[datum]."'>".$row['datum']. "</OPTION><BR>"; } }
echo "</SELECT></div>"; ?>Startdatum:<BR><SELECT name="year"><OPTION>2006</OPTION><OPTION>2007</OPTION></SELECT><SELECT name="month"><?php for ($i = 1; $i <= 12; $i++) { echo "<OPTION value='$i'>$i</OPTION>"; } ?> <?php echo "</SELECT>"; ?><SELECT name="month"><?php for ($i = 1; $i <= 31; $i++) { echo "<OPTION value='$i'>$i</OPTION>"; } ?><?php echo "</SELECT><BR><BR>Lista:<BR><SELECT name=\"lista\"><OPTION "; if($_POST[lista]=="5") { echo "selected"; } ?>>5</OPTION><OPTION <?php if($_POST[lista]=="10") { echo "selected"; } ?>>10</OPTION><OPTION <?php if($_POST[lista]=="15") { echo "selected"; } ?>>15</OPTION></SElECT><?php echo "<br><INPUT type='hidden' name='resub' value='yes'><INPUT TYPE=SUBMIT value=Generera></FORM>"; ?><BR>
</td><td width="3"></td><td valign="top">
<?php echo $_POST[lista]; if($_POST[lista]=="5") { ?>
<?php $list2="list=".$_POST[lista]."&"; ?>
<Iframe id="5" frameborder="1" width="690" height="400" src="cal/index-test.php?<?php echo $list2; ?>list=&d0=<?php echo $list[0]; ?>&d1=<?php echo $list[1]; ?>&d2=<?php echo $list[2]; ?>&d3=<?php echo $list[3]; ?>&d4=<?php echo $list[4]; ?>"></iframe><?php } ?>
<?php if($_POST[lista]=="10") { ?>
<?php $list2="list=".$_POST[lista]."&"; ?>
<Iframe id="10" frameborder="1" width="690" height="400" src="cal/index-test.php?<?php echo $list2; ?>d0=<?php echo $list[0]; ?>&d1=<?php echo $list[1]; ?>&d2=<?php echo $list[2]; ?>&d3=<?php echo $list[3]; ?>&d4=<?php echo $list[4]; ?>&d5=<?php echo $list[5]; ?>&d6=<?php echo $list[6]; ?>&d7=<?php echo $list[7]; ?>&d8=<?php echo $list[8]; ?>&d9=<?php echo $list[9]; ?>"></iframe><?php } ?>
<?php if($_POST[lista]=="15") { ?>
<?php $list2="list=".$_POST[lista]."&"; ?>
<Iframe id="15" frameborder="1" width="690" height="400" src="cal/index-test.php?<?php echo $list2; ?>d0=<?php echo $list[0]; ?>&d1=<?php echo $list[1]; ?>&d2=<?php echo $list[2]; ?>&d3=<?php echo $list[3]; ?>&d4=<?php echo $list[4]; ?>&d5=<?php echo $list[5]; ?>&d6=<?php echo $list[6]; ?>&d7=<?php echo $list[7]; ?>&d8=<?php echo $list[8]; ?>&d9=<?php echo $list[9]; ?>&d10=<?php echo $list[10]; ?>&d11=<?php echo $list[11]; ?>&d12=<?php echo $list[12]; ?>&d13=<?php echo $list[13]; ?>&d14=<?php echo $list[14]; ?>"></iframe><?php } ?>
</td></table>
