<?
session_start();
$us= $HTTP_SESSION_VARS['uid'];
//echo "user=$us<br>";
?>
<LINK REL="stylesheet" TYPE="text/css" HREF="menu.css">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=KOI8-R">
<title>Menu - list</title>
</head>
<body class="speise">
<?
include("menu.ini");
echo "<form name=edit_speise method=POST action=rezult_speise.php>";
$strsql_5 = "select p.speise_name,p.speise_id, t.type_name ,p.speise_recept from speise p, speise_type t where ( (p.speise_id='$_GET[speise_id]') and(p.speise_type=t.type_id) and (t.user_id='$us'));";
echo "speise=$strsql_5<br>";
$result_5 = mysql_query($strsql_5, $connection);
$r=0;
while ( $row_5 = mysql_fetch_row($result_5) )
{
$r+=1;
echo "<center><B><input type=text name=speise_name value=$row_5[0]></B><BR><input type=text name=type_name value=$row_5[2]></center><P>";
echo "<B>Teiles</B>:";
$strsql_6 = "select p.prod_name from product p, teil t where ( (t.speise_id='$row_5[1]') and (p.prod_id=t.prod_id));";
echo "teil = $strsql_6 <br>";
$result_6 = mysql_query($strsql_6, $connection);
$y=0;
while ( $row_6 = mysql_fetch_row($result_6) )
{
$y+=1;
echo "$row_6[0] ";
}
echo "<P><BLOCKQUOTE>$row_5[3]</BLOCKQUOTE><P>";
}
?>
<TR><TD COLSPAN=7 align=center><INPUT type=submit value=Edit name=Edit><TD></TR>
</form>
</TABLE>