Location: PHPKode > projects > Einkaufszettelgenerator > EZettel0.1/speise.php
<?
session_start();
$us= $HTTP_SESSION_VARS['uid'];
//echo "user=$us<br>"; 
?>
<HTML>
<LINK REL="stylesheet" TYPE="text/css" HREF="menu.css"> 
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head> 

<body class="speise">    
<?

include("menu.ini"); 

  $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'));"; 
  $result_5 = mysql_query($strsql_5, $connection);
   $r=0;
  while ( $row_5 = mysql_fetch_row($result_5) )
   {
 $r+=1;
 echo "<center><B>$row_5[0]</B><BR>$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]')&&(p.prod_id=t.prod_id));";
  $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>";     

    }
?>
<center><A HREF=speise_list.php>К списку рецептов</a>&nbsp;&nbsp;<A HREF=start.php>на первую страницу</a></center>      

</HTML> 
Return current item: Einkaufszettelgenerator