Codice PHP:
 session_start();
if(!isset(
$_SESSION['nick']))
{
header("Location:logout.php");
exit();
}

if(
$_GET)
            {
            
$id=$_GET['id'];
            
$i=$_GET['i'];    
            echo 
"a".$id."b".$i;
include 
'include/header.inc.php';
include 
'include/left.inc.php';
     echo
" <td bgcolor=#ffcc66><center>";            
            echo 
"
            
            <form method=post action=\"
$_SERVER[PHP_SELF]\">
            <table>
            <tr>
            <td>
            <caption>Inserimento nuovi prodotti </caption>
            </td>
            </tr>
            </table>
            <hr>

            "
;
            for(
$j=0;$j<$i;$j++)
            {
            echo 
"
                    <table>
                    <tr>
                    <td>Marca</td>
                    <td><input type=text name=marca[
$j]></td>
                    </tr>
                    <tr>
                    <td>Modello</td>
                    <td><input type=text name=mod[
$j]></td>
                    </tr>
                    <tr>
                    <td>Colore</td>
                    <td><input type=text name=col[
$j]></td>
                    </tr>
                    <tr>
                    <td>Origine</td>
                    <td><input type=text name=orig[
$j]></td>
                    </tr>
                    <tr>
                    <td>Disponibilità</td>
                    <td><input type=text name=disp[
$j]></td>
                    </tr>
                    <tr>
                    <td>Prezzo Privato</td>
                    <td><input type=text name=prezzo[
$j]></td>
                    </tr>
                    <tr>
                    <td>Prezzo Azienda</td>
                    <td><input type=text name=prezzoaz[
$j]></td>
                    </tr>
                    <tr>
                    <td>Prezzo Rivenditori</td>
                    <td><input type=text name=prezzoriv[
$j]></td>
                    </tr>
                
                    </table>
                    <hr>

                "
;
            }
            
            echo 
"
            <table>
            <tr>
            <td>
            <input type=hidden name=id value=
$id>
            <input type=submit name=submit value=Edita>
            </td>
            </tr>
            </table>
            </form>
            </center>
            "
;
            echo 
"</td>";
     include 
'include/right.inc.php';
        include 
'include/footer.inc.php';
            
            }
else if(
$_POST)
{
$marca=addslashes($_POST['marca']);
     
$mod=addslashes($_POST['mod']);
     
$col=addslashes($_POST['col']);
     
$orig=addslashes($_POST['orig']);
     
$disp=addslashes($_POST['disp']);
     
$prezzo=addslashes($_POST['prezzo']);
     
$prezzoaz=addslashes($_POST['prezzoaz']);
     
$prezzoriv=addslashes($_POST['prezzoriv']);
     
$id=addslashes($_POST['id']);
     include 
'include/conf.inc.php';
     
$sql=mysql_query("update tbl_prodotti set marca='$marca',modello='$mod',tipo='$col',origine='$orig',qt='$disp',prezzo='$prezzo',prezzoaz='$prezzoaz',prezzoriv='$prezzoriv' where id_categorie='$id'").mysql_error();

allora come si vede creo tramite un ciclo for una tabella per l'inserimento delle caratteristiche di un prodotto. tramiter for ne creo quanti ne vuole inserire l'utente ossia $i

il problema è la query
come inserire i vari dati tramite queri essendo che tramite la query che ho scritto mi sovvrascrive i valori

grazie per la dispon.