problem with $_POST[] e mySQL

[flyfly]

hello !!!

example: I have some global $_POST[] from e site like these :

articolo1 = 11111
nome1 = 'AAAAA'
costo1 = 10000

articolo2 = 22222
nome2 = 'BBBBB'
costo2 = 20000

articolo3 = 33333
nome3 = 'CCCCC'
costo3 = 30000

I would like to insert them into my db in dynamical way :

I tried this script but dont work
/////////
for ($var = 0; $var < 3; $var++){

$qry = "INSERT INTO prodotti ( articolo,nome,costo)
VALUES ('$POST['articolo'.$var]','$POST['nome'.$var]','$_POST['costo'.$var]') ";
$result = mysql_query($qry,$db);
};
///////
is there someone that can helpme ?

Thanks

fly

[yao1965]

Hi!

I guess that you only insert two records if your insert statement is correct.

In your for loop, you start index 0 instead of 1, but your variables start at 1. So if you change your for loop start at 1, then it should work.

i.e.
for($var = 1; $var < 4; $var++) {
//your insert statement goes here.
}

  I hope this will help.