<?php
     include '../conf.php';  
                                 mysql_connect($host,$username,$password);
                                 @mysql_select_db($database) or die("Nie znaleziono bazy danych");
                                 $wynik = mysql_query("SELECT * FROM menu");
                            
                                 echo '<center>';
                                 echo 'Zmiana układu menu';
                                 echo '

';  
                                 print("<form name=\"new\" method=\"post\" action=\"menu-zmiana2.php\">");                                
                                 while($r = mysql_fetch_assoc($wynik))
                                 echo $r['nazwa'].'<input name="'.$r['nazwa'].'" value="'.$r['id'].'">';
                                 echo '
';
                                 print("<input type=\"submit\" value=\"Wyślij\">");
                                 echo ' ';
                                 print("<input type=\"reset\" value=\"Wyczyść\">");
                                 print("</form>");
mysql_close();
?>

<?php
     include '../conf.php';  
    
                                 mysql_connect($host,$username,$password);
                                 @mysql_select_db($database) or die("Nie znaleziono bazy danych");
                                 $wynik = mysql_query("SELECT * FROM menu");
                                 $num=mysql_numrows($wynik);
                                 $i=0;
while ($i < $num) {
$naz=mysql_result($wynik,$i,"nazwa");
$id=$_POST['$naz'];

$result1 = "UPDATE menu SET id='$id' WHERE nazwa='$naz'";
                     mysql_query($result1);


echo $id;
  
$i++;
}

?>