Help me with that loop stuff

delfa

I have in a db 2 columns (nome and cores).
For each one of the columns i have to insert 3 rows.
I can´t organize the submitted values and put them in their respective column!

Can you help me with that loop, it´s doesn´t seam to work:

<? 
 for($i=1;$i<=3;){
?>
<td width="24%"><input name="cores<? echo $i; ?>" type="text" id="cores"></td>
<td width="76%"><input name="nome<?  echo $i; ?>" type="text" id="nome"></td>

<? } ?>


$insertSQL = "INSERT INTO teste (nome, cores)  VALUES ";
$maxval = max($HTTP_POST_VARS);
echo $maxval;
for ($i = 1; $i < $maxval;) {
$insertSQL .= "('\"$nome\"', '\"$cores\"') ,"; 
$i++;
} 

$insertSQL .= " (NULL, NULL) ";

$Result1 = mysql_query($insertSQL, $vidisco);

planetsim

1) You cannot do that in a for loop
2) It seems like you wanna update mulitple rows. There can be two ways. One without a loop at all, and the other with a loop

You can use a do while() while and a for loop for it

But you can only use numbers and vars no html or anything like that.

barand

First, get rid of the image tag from the 'for' statement and use arrays cores[] and nome[].

<? 
 for($i=1;$i<=3; $i++) {
?>
<tr><td width="24%"><input name="cores[]" type="text" id="cores"></td>
<td width="76%"><input name="nome[]" type="text" id="nome"></td></tr>

<? } ?>

Your receiving php will then receive cores[0], cores[1] and cores[2]. Similarly with nome[] array.

So,

$nome = $_POST['nome'];
$cores = $_POST['cores'];
for ($i=0; $i < 3; $i++) {
  $n = $nome[$i];   $c =cores[$i];
  mysql_query("insert into table (nome, cores) values ('$n', '$c')");
}

hth

delfa

$insertSQL .= "INSERT INTO teste (nome, cores)  VALUES ";
for ($i=0; $i <= 2;$i++) {
$nome = $nome[$i];
$cores = $cores[$i];  

$insertSQL .= "('$nome', '$cores'), ";

}
$insertSQL .= " ('NULL', 'NULL')";
$Result1 = mysql_query($insertSQL, $vidisco);

It only inserts the name[3] and cores[3] in the database
the others (1 and 2) are empty!

what´s happening
is it because the null ?

barand

you need to call the query within the loop. delete line with nulls.

delfa

yes but i´m using this:

$insertSQL .= " ('NULL', 'NULL')";

because of the comma in the $insertSQL query .

Do u have another ideia?

barand

Yes, do what I did in my original posting

$nome = $_POST['nome'];
$cores = $_POST['cores'];
for ($i=0; $i < 3; $i++) {
  $n = $nome[$i];   $c = cores[$i];
  mysql_query("insert into teste (nome, cores) values ('$n', '$c')");
}

delfa

Thax man !

it finally worked!