adding variables2

[mrdance]

I have a form with the some input boxes. The have the name="kronor1" name="kronor2". The form is sent to a script. I assume the values will be stored in $kronor1 and $kronor2. I have this code in the php-script;

$kronor="kronor";

for ($i=1; $i<=4; $i++)
{
if (($.$kronor.$i)=="")
{
continue;
}
else {
$sql = "INSERT INTO likvid (kronor) VALUES (($.$kronor.$i))";

My problem isn't the mysql syntax på adding variables. I had an array that worked before but for several reasons I would like to have this solution. Please help me.

[Anon]

You probably would want to add single quotes to your values. Tour SQL statement would then look like this:
"INSERT INTO likvid (kronor) VALUES ('$kronor.$i')";

[mrdance]

I tried that too, it did't work. I saved $kronor.$i.

/ Henrik

[fross]

Henrik wrote:

[snip]

$sql = "INSERT INTO likvid (kronor) VALUES (($.$kronor.$i))";

i think you have to do something like:

eval("\$sqlkronor = \"$.$kronor.$i\";");
$sql = "INSERT INTO likvid (kronor) VALUES ($sqlkronor)";

by the way, isn't the syntax you're looking for above meant to be $$kronor or ${$kronor}?

david