Multiple Sql Entries

[rodsote]

Hi i got this problem i want to make multiple entries to an sql db i have put this code but i dont get the code to enter the results.

This is the form code:

<form name="form1" method="post" action="?act=do">
<?
for ($x=1; $x<=$5; $x++){
?>
<input name="name<? echo $x; ?>" type="text" size="5">
<?
}
?>

This is the entry coder for the sql:

$num=0;
while ($num<5){
$num++;

$query[$num]=mysql_query("insert into users values ('$fecha[$num]')");
}

[planetsim]

Firstly why not just make this an array

<input name="name<? echo $x; ?>" type="text" size="5">

to

<input name="name[]" type="text" size="5">

Also what is the exact problem with the Query are you getting any errors?

[rodsote]

Hi!

The problem is that the query is not entering the results to the db because the variables are not recornized.

[rachel2004]

Let's start with the basics:

What type of database are you inserting into? MySQL, Postgres, Oracle... ?

What is the name of the table you are inserting into and what are the exact column names and data types?

[jcantrell]

If I'm understanding what you are doing, you are using a variable variable.

Variable 1 = $name1
Variable 2 = $name2

$name$x won't work, ,neither will $name[$x] (which would be an array)

What you need to do is this,

while ($num<5){
$num++;
$namevar = "name$x";
$thisname = ${$namevar}; // This is the imporant part of this reply.

// Do insert query here. Insert $thisname for name
}

For more information about variable variables check here:
http://php.us.themoes.org/manual/en/language.variables.variable.php

[rodsote]

Ey thanks alot for your posts i will tried them and see wich one worked for me.