guten morgen alle zusammen,
ich habe folgende datei:
PHP-Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Daten ausgeben</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<!-- HEADER -->
<div id="header">
<div>Daten ausgeben
<hr>
</div><br />
<!-- TABS -->
<div id="tabs">
<a href="int_eintragen.php"><div id="tab_eintragen">Daten eintragen</div></a>
<a href="int_aendern.php"><div id="tab_aendern">Daten ändern</div></a>
<a href="int_ausgeben.php"><div id="tab_ausgeben">Daten ausgeben</div></a>
</div>
<!-- CONTAINER -->
<div id="container">
<div>
<form action="int_ausgeben.php" method="post">
<!-- ABTEILUNG & KALENDERWOCHE -->
<div id="content_option">
<select id="content_option_select" name="abteilung" size="1">
<option>BBK</option>
<option>Dragee</option>
<option>MAOAM</option>
<option>Füllabteilung</option>
</select>
<input id="content_option_input" type="text" name="von_kw" size="13" maxlength="10"
value="Kalenderwoche" onclick="if(this.value && this.value==this.defaultValue)this.value=''" /> <span id="content_option_input">bis</span>
<input id="content_option_input" type="text" name="bis_kw" size="13" maxlength="10"
value="Kalenderwoche" onclick="if(this.value && this.value==this.defaultValue)this.value=''" />
</div>
<!-- BUTTON -->
<div align="right"><input type="submit" name="button_ausgeben" value="Abrufen" /></div>
</form>
</div></div>
<?php
if(isset($_POST['button_ausgeben'])){
// Einstellungen abfragen
$von_kw = $_POST['von_kw'];
$bis_kw = $_POST['bis_kw'];
$abteilung = $_POST['abteilung'];
$num1=array();$be1=array();
$num2=array();$be2=array();
$num3=array();$be3=array();
$num4=array();$be4=array();
// Array parameter
$x1 = 0;
$x2 = 1;
$x3 = 2;
$x4 = 3;
$x5 = 4;
$x6 = 5;
// Datenbankdaten einbinden
include("dbconnect.php");
$rows = array("NUM I", "Bemerkung I", "NUM II", "Bemerkung II", "NUM III", "Bemerkung III", "NUM IV", "Bemerkung IV");
while($von_kw <= $bis_kw)
{
$kw = $von_kw;
$von_kw ++;
$abfrage = "SELECT * FROM `$kw` ORDER BY ID";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_array($ergebnis))
{
// Werte der SQL-Abfrage an Array
$num1[]= $row ["NUM I"]; $be1[]= $row ["Bemerkung I"];
$num2[]= $row ["NUM II"]; $be2[]= $row ["Bemerkung II"];
$num3[]= $row ["NUM III"]; $be3[]= $row ["Bemerkung III"];
$num4[]= $row ["NUM IV"]; $be4[]= $row ["Bemerkung IV"];
// NUMS addieren
$add = array( $row->$rows[0], $row->$rows[1], $row->$rows[2], $row->$rows[3],
$row->$rows[4], $row->$rows[5], $row->$rows[6], $row->$rows[7]);
$summe = array_sum($add);
}// While Schleife SQL
echo'
<br />
<!-- CONTAINER -->
<div id="container">
<div>
<form action="int_ausgeben.php" method="post">
<!-- ÜBERSCHRIFTEN -->
<table cellspacing="4">
<tr>
<td></td>
<td id="content_beschriftung">Bemerkung I</td>
<td id="content_beschriftung">Bemerkung II</td>
<td id="content_beschriftung">Bemerkung III</td>
<td id="content_beschriftung">Bemerkung IV</td>
</tr>
<!-- MONTAG -->
<tr>
<td id="content_beschriftung">Montag</td>
<td><input id="content_input" type="text" name="num1_mo" size="2" maxlength="100" value='.$num1[$x1].' /> <input id="content_input" type="text" name="data1_mo" size="11" maxlength="100" value='.$be1[$x1].' /></td>
<td><input id="content_input" type="text" name="num2_mo" size="2" maxlength="100" value='.$num2[$x1].' /> <input id="content_input" type="text" name="data2_mo" size="11" maxlength="100" value='.$be2[$x1].' /></td>
<td><input id="content_input" type="text" name="num3_mo" size="2" maxlength="100" value='.$num3[$x1].' /> <input id="content_input" type="text" name="data3_mo" size="11" maxlength="100" value='.$be3[$x1].' /></td>
<td><input id="content_input" type="text" name="num4_mo" size="2" maxlength="100" value='.$num4[$x1].' /> <input id="content_input" type="text" name="data4_mo" size="11" maxlength="100" value='.$be4[$x1].' /></td>
</tr>
<!-- DIENSTAG -->
<tr>
<td id="content_beschriftung">Dienstag</td>
<td><input id="content_input" type="text" name="num1_di" size="2" maxlength="100" value='.$num1[$x2].' /> <input id="content_input" type="text" name="data1_di" size="11" maxlength="100" value='.$be1[$x2].' /></td>
<td><input id="content_input" type="text" name="num2_di" size="2" maxlength="100" value='.$num2[$x2].' /> <input id="content_input" type="text" name="data2_di" size="11" maxlength="100" value='.$be2[$x2].' /></td>
<td><input id="content_input" type="text" name="num3_di" size="2" maxlength="100" value='.$num3[$x2].' /> <input id="content_input" type="text" name="data3_di" size="11" maxlength="100" value='.$be3[$x2].' /></td>
<td><input id="content_input" type="text" name="num4_di" size="2" maxlength="100" value='.$num4[$x2].' /> <input id="content_input" type="text" name="data4_di" size="11" maxlength="100" value='.$be4[$x2].' /></td>
</tr>
<!-- MITTWOCH -->
<tr>
<td id="content_beschriftung">Mittwoch</td>
<td><input id="content_input" type="text" name="num1_mi" size="2" maxlength="100" value='.$num1[$x2].' /> <input id="content_input" type="text" name="data1_mi" size="11" maxlength="100" value='.$be1[$x2].' /></td>
<td><input id="content_input" type="text" name="num2_mi" size="2" maxlength="100" value='.$num2[$x2].' /> <input id="content_input" type="text" name="data2_mi" size="11" maxlength="100" value='.$be2[$x2].' /></td>
<td><input id="content_input" type="text" name="num3_mi" size="2" maxlength="100" value='.$num3[$x2].' /> <input id="content_input" type="text" name="data3_mi" size="11" maxlength="100" value='.$be3[$x2].' /></td>
<td><input id="content_input" type="text" name="num4_mi" size="2" maxlength="100" value='.$num4[$x2].' /> <input id="content_input" type="text" name="data4_mi" size="11" maxlength="100" value='.$be4[$x2].' /></td>
</tr>
<!-- DONNERSTAG -->
<tr>
<td id="content_beschriftung">Donnerstag</td>
<td><input id="content_input" type="text" name="num1_do" size="2" maxlength="100" value='.$num1[$x3].' /> <input id="content_input" type="text" name="data1_do" size="11" maxlength="100" value='.$be1[$x3].' /></td>
<td><input id="content_input" type="text" name="num2_do" size="2" maxlength="100" value='.$num2[$x3].' /> <input id="content_input" type="text" name="data2_do" size="11" maxlength="100" value='.$be2[$x3].' /></td>
<td><input id="content_input" type="text" name="num3_do" size="2" maxlength="100" value='.$num3[$x3].' /> <input id="content_input" type="text" name="data3_do" size="11" maxlength="100" value='.$be3[$x3].' /></td>
<td><input id="content_input" type="text" name="num4_do" size="2" maxlength="100" value='.$num4[$x3].' /> <input id="content_input" type="text" name="data4_do" size="11" maxlength="100" value='.$be4[$x3].' /></td>
</tr>
<!-- FREITAG -->
<tr>
<td id="content_beschriftung">Freitag</td>
<td><input id="content_input" type="text" name="num1_fr" size="2" maxlength="100" value='.$num1[$x4].' /> <input id="content_input" type="text" name="data1_fr" size="11" maxlength="100" value='.$be1[$x4].' /></td>
<td><input id="content_input" type="text" name="num2_fr" size="2" maxlength="100" value='.$num2[$x4].' /> <input id="content_input" type="text" name="data2_fr" size="11" maxlength="100" value='.$be2[$x4].' /></td>
<td><input id="content_input" type="text" name="num3_fr" size="2" maxlength="100" value='.$num3[$x4].' /> <input id="content_input" type="text" name="data3_fr" size="11" maxlength="100" value='.$be3[$x4].' /></td>
<td><input id="content_input" type="text" name="num4_fr" size="2" maxlength="100" value='.$num4[$x4].' /> <input id="content_input" type="text" name="data4_fr" size="11" maxlength="100" value='.$be4[$x4].' /></td>
</tr>
<!-- SAMSTAG -->
<tr>
<td id="content_beschriftung">Samstag</td>
<td><input id="content_input" type="text" name="num1_sa" size="2" maxlength="100" value='.$num1[$x5].' /> <input id="content_input" type="text" name="data1_sa" size="11" maxlength="100" value='.$be1[$x5].' /></td>
<td><input id="content_input" type="text" name="num2_sa" size="2" maxlength="100" value='.$num2[$x5].' /> <input id="content_input" type="text" name="data2_sa" size="11" maxlength="100" value='.$be2[$x5].' /></td>
<td><input id="content_input" type="text" name="num3_sa" size="2" maxlength="100" value='.$num3[$x5].' /> <input id="content_input" type="text" name="data3_sa" size="11" maxlength="100" value='.$be3[$x5].' /></td>
<td><input id="content_input" type="text" name="num4_sa" size="2" maxlength="100" value='.$num4[$x5].' /> <input id="content_input" type="text" name="data4_sa" size="11" maxlength="100" value='.$be4[$x5].' /></td>
</tr>
</table>
<!-- ABTEILUNG & KALENDERWOCHE -->
<div id="content_option">
<select id="content_option_select" value='.$abteilung.' name="abteilung" size="1">
<option>BBK</option>
<option>Dragee</option>
<option>MAOAM</option>
<option>Füllabteilung</option>
</select>
<input id="content_option_input" type="text" value='.$kw.' name="kw" size="13" maxlength="10" /></div>
<!-- BUTTON -->
<div align="right"><input type="submit" name="button_aendern" value="Ändern" /></div>
</form>
</div></div>';
} // While Schleife kw
} // Submit?
?>
</body>
</html>
es liegen 2 testtabellen auf meiner datenbank mit dem namen
34 und
35
der user sind nun ein ein interface mit 2 input text Kalenderwoche bis Kalenderwoche. Dort gibt er die Start und end kalenderwoche ein.
wenn er jetzt als start kw 34 eingibt und als end kw 40 dann soll er mir alle tabellen aus der datenbank mit den namen 34, 35, 36, 37 , 38, 39 und 4o ausgeben.
die ausgabe erfolgt auch, aber meine tabellen werden immer nur mit den werten der start kw gefüllt. warum?
15.10.2009, 11:16
ausgeben von mehreren tabellen mysql 
