Updating value of multiple text fields to MYSQl

[xox]

I have problem that only last text field  is updated, how should I fix this?

 

Here's the code

<?php
if(isset($_POST["update"])){
mysql_query("UPDATE categories SET name_category = '".$_POST['category']."'  WHERE ID= ".$_POST['currentCat']." ") or die(mysql_error());
mysql_query("UPDATE podkategorije SET name_subcategory = '".$_POST['subcategory']."'  WHERE id_subCat= ".$_POST['currentSubCat']." ") or die(mysql_error());
}
?>
<form action="" method="post" >
<?php

//creating texfields from db

$query = "SELECT k.ID, k.name_category, pk.name_subcategory, pk.id_subCat
          FROM `categories` AS k
          JOIN `subcategories` AS pk ON pk.id_mainCat = k.ID";
$result = mysql_query($query) or die(mysql_error());
$currentCat = false;
while($row = mysql_fetch_array($result))
{
    //so it doesn't repeat itself
    if($currentCat != $row['ID'])
    {
        //display of main Categories
	?>

	<ul>
	<li>
	<br/><input name="categories" type="text" value="<?php  echo $row['name_category']; ?>" />
	</li>
	</ul>

	<?
	$currentCat = $row['ID'];

    }
    //display subcategories
?>
<input name="subcategories" type="text" value="<?php  echo $row['name_category']; ?>" /><br/>
<input type="hidden" name="currentCat" value="<?php echo $row['ID']; ?>" />
<input type="hidden" name="currentSubCat" value="<?php echo $row['id_subCat']; ?>" />
<?
}
?>
<br />
<input type="button" value="Back" onClick="history.go(-1);return true;">
<input type="submit" value="Update" name="update"/>
</form>

 

 

[xox]

Ok, made few changes, but site just reloads and values aren't update... any idea?

<?php
if(isset($_POST["posodobi"]))
{
        for($i=0;$i<sizeof($_POST["id"]);$i++)
        {
        echo"UPDATE podkategorije SET ime_podkategorije = '".$_POST['podkategorije'][$i]."'  WHERE id_podkategorij=".$_POST['trenutnaPodkategorija'][$i].";" or die(mysql_error());
        
        $shrani ="UPDATE podkategorije SET ime_podkategorije = '".$_POST['podkategorije'][$i]."'  WHERE id_podkategorij=".$_POST['trenutnaPodkategorija'][$i].";" or die(mysql_error());
        mysql_query($shrani);
        echo "UPDATE kategorije SET ime_kategorije = '".$_POST['kategorije'][$i]."'  WHERE ID=".$_POST['trenutnaKat'][$i].";" or die(mysql_error());
        $shraniKat="UPDATE kategorije SET ime_kategorije = '".$_POST['kategorije'][$i]."'  WHERE ID=".$_POST['trenutnaKat'][$i].";" or die(mysql_error());
        mysql_query($shraniKat);
        }
}
?>
<form action="" method="post" >
<?php

//preimenovanje kategorij/podkategorij

        $query = "SELECT k.ID, k.ime_kategorije, pk.ime_podkategorije, pk.id_podkategorij
         FROM `kategorije` AS k
         JOIN `podkategorije` AS pk ON pk.id_glavne_kategorije = k.ID";
        $result = mysql_query($query) or die(mysql_error());
        $trenutnaKat = false;
while($row = mysql_fetch_array($result))
{
        $stevec++;
    //da se ne ponavlja
    if($trenutnaKat != $row['ID'])
    { 
        //izpis glavne kategorije
                ?>
                
                <ul>
                <li>
                <br/><input name="kategorije" type="text" value="<?php  echo $row['ime_kategorije']; ?>" />
                </li>
                </ul>
                
                <?
                $trenutnaKat = $row['ID'];
                
    }
    //izpis podkategorije
        ?>
        <input name="podkategorije" type="text" value="<?php  echo $row['ime_podkategorije']; ?>" /><br/>
        <input type="hidden" name="trenutnaKat" value="<?php echo $row['ID']; ?>" />
        <input type="hidden" name="trenutnaPodkategorija" value="<?php echo $row['id_podkategorij']; ?>" />
        <?
}
echo '<input type="hidden" name="id[]" value="'.$stevec.'">';
?>
<br />
<input type="button" value="Nazaj" onClick="history.go(-1);return true;">
<input type="submit" value="Posodobi" name="posodobi"/>
</form>

[gizmola]

Read this.