Hi,
Got a couple of problems. What I wrote reads some information out of two different MySQL tables and presents a table with different forms.
I can get the forms working only one at a time (the Update works), and I can't get the field values showing up again after submitting.
Can someone help me? If so please mail me, somehow I can't open this site from home. :-(
Here my script:
<?
if ($senden){
echo$sende;
$db=mysql_connect('192.168.0.104','root','');
if (!$db) {
die("Probleme bei der Datenbankauswahl!<br>");
}
mysql_select_db("dozpool");
for($sende=0;$sende=count($zaehler);$sende++){
$j=$sende;}
$sqlab="UPDATE tbl_d_th";
$sqlab.=" SET d_th_detailthema_divers='$detailthema_divers[$sende]', honorar_anfaenger_sgb3='$anfaenger_sgb3[$sende]', honorar_anfaenger_firma='$anfaenger_firma[$sende]', honorar_standard_sgb3='$standard_sgb3[$sende]', honorar_standard_firma='$standard_firma[$sende]', honorar_fortgeschritten_sgb3='$fortgesch_sgb3[$sende]', honorar_fortgeschritten_firma='$fortgesch_firma[$sende]'";
echo$sqlab.=" WHERE id_d='$Daten' AND id_gesamtthema='$zeile'";
echo"<br>";
$result = mysql_query($sqlab);
}
global $i;$i=0;
global $reihe;
global $zaehler;
global $zeile;
global $gesamt;
global $thema;
$Daten= '303c6bae525d613';
?>
<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.0 Transitional//EN'>
<head>
<title>honorar</title>
<style type='text/css'>
<!--
h3 {
font-family : Arial, Helvetica, sans-serif;
font : bold;
}
input{
font : bold 12px Arial, Helvetica, sans-serif;
}
td.ueberschrift{
background-color : Teal;
border-bottom : thin groove Silver;
font : bold 14px Arial, Helvetica, sans-serif;
}
td.thema{
font : bold 14px Arial, Helvetica, sans-serif;
}
td.norm{
border-bottom : thin solid Teal;
font : bold 12px Arial, Helvetica, sans-serif;
}
-->
</style>
</head>
<body bgcolor='#ccd4e6' text='#000000'>
<div align='center'>
<h3>Honorarart</h3>
</div>
<div align='center'>
<table width='100%' border='0' cellspacing='0' cellpadding='0' align='center'>
<tr>
<td class='ueberschrift' height='29' width='140'>
<div align='center'>Thema</div>
</td>
<td class='ueberschrift' width='10'> </td>
<td class='ueberschrift' height='29' width='110'>
<div align='center'>Seminarart</div>
</td>
<td class='ueberschrift' height='29' width='110'>
<div align='center'>Anfänger</div>
</td>
<td class='ueberschrift' height='29' width='110'>
<div align='center'>Standard</div>
</td>
<td class='ueberschrift' height='29' width='140'>
<div align='center'>Fortgeschrittenen</div>
</td>
</tr>
<tr>
<td height='14' colspan='6'> </td>
</tr>
<?
// Abfrage der MySQL-Datenbank
$db=mysql_connect('192.168.0.104','root','');
if (!$db) {
die("Probleme bei der Datenbankauswahl!<br>");
}
mysql_select_db("dozpool");
$sql_befehl = "SELECT id_gesamtthema FROM tbl_d_th WHERE id_d = '$Daten'";
$result = mysql_query($sql_befehl);
while ($zeile = mysql_fetch_row($result)){
foreach($zeile as $gesamt){
$hauptthema = substr($gesamt,0,4);echo"<br>";
$oberthema = substr($gesamt,4,8);
$detailthema = substr($gesamt,12,25);
}
$sql_befehl_2 = "SELECT thema FROM tbl_th_detailthema";
$sql_befehl_2 .= " WHERE id_th_detailthema='$detailthema'";
$sql_befehl_2 .= " AND id_th_hauptthema='$hauptthema'";
$sql_befehl_2 .= " AND id_th_oberthema='$oberthema'";
$result_2 = mysql_query($sql_befehl_2);
$zeile_2 = mysql_fetch_array($result_2);
echo"
<tr>
<td class='thema' height='21'>";
$anzahl=count($zeile_2);
if ($anzahl>1){
echo"<br>
<form name='form$i' method='post' action='$PHP_SELF'>
$zeile_2[0]<br>
<input type='hidden' name='i' value='$i;'><br>
<input type='hidden' name='Daten' value='$Daten'><br>
<input type='hidden' name='zeile' value='$zeile[0]'>";
$zeile[0];
$zaehler[]=$i;
$a=count($zaehler);
}else{echo "Sie haben noch keinen Themenbereich gewählt!";}
echo"
</td>
<td class='norm' width='10' rowspan='2'> </td>
<td class='norm' height='21'>SGB3</td>
<td class='norm' height='21'>
<div align='center'>";?>
<input type='text' name='anfaenger_sgb3[]' size='5' value='<?if($senden)echo$anfaenger_sgb3[$i];?>'>
<?echo" EUR </div>
</td>
<td class='norm' height='21'>
<div align='center'>";?>
<input type='text' name='standard_sgb3[]' size='5' value='<?if($senden)echo$standard_sgb3[$i];?>'>
<?echo" EUR </div>
</td>
<td class='norm' height='21'>
<div align='center'>";?>
<input type='text' name='fortgesch_sgb3[]' size='5' value='<?if($senden)echo$fortgesch_sgb3[$i];?>'>
<?echo" EUR </div>
</td>
</tr>
<tr>
<td class='norm'>
<div align='center'>
<br>Sonstiges Eingeben<br>(zB.- Version)<br>";?>
<input type='text' name='detailthema_divers[]' size='20' maxlength='50' value='<?if($senden)echo$detailthema_divers[$i];?>'>
<?echo"</div>
</td>
<td class='norm' height='12'>Firmenschulung</td>
<td class='norm' height='12'>
<div align='center'>";?>
<input type='text' name='anfaenger_firma[]' size='5' value='<?if($senden)echo$anfaenger_firma[$i];?>'>
<?echo" EUR </div>
</td>
<td class='norm' height='12'>
<div align='center'>";?>
<input type='text' name='standard_firma[]' size='5' value='<?if($senden)echo$standard_firma[$i];?>'>
<?echo" EUR </div>
</td>
<td class='norm' height='12'>
<div align='center'>";?>
<input type='text' name='fortgesch_firma[]' size='5' value='<?if($senden)echo$fortgesch_firma[$i];?>'>
<?echo" EUR </div>
</td>
<tr>";
$sende=$i;
echo"<td class='norm' colspan='6' align='right'>
<input type='submit' name='senden' value='senden $i'>
</td>
</tr>
</tr>
<tr>
<td class='norm' height='14' colspan='6'> </td>
</tr>
</form>";echo$senden;$i=$i+1;
}
?>
<tr>
<td colspan="6" height="10"> </td>
</tr>
<tr>
<td width="140"> </td>
<td width="230" colspan="3" align="right">
<form action="" method="POST" name="weiter">
<input name='Daten' type='hidden' value=<?php echo $Daten?>>
<input type="image" src="images/weiter.jpg">
</form>
</td>
<td width="250" colspan="2"> </td>
</tr>
</table>
</div>
</body>
Thanks a lot for any possible help!!!
Alex from Berlin, Germany.
