Posted by Garry Jones on 04/26/06 13:41

I want to simplify the following code.

I have 4 variables which are to be read in up to ten times. When read in
these are to be written to an SQL database. The value of $ct tells me when
to stop reading in these 4 variables. Each time I read in the group of 4
variables I need to increase $fx by 1 and read in additional values for each
group of variables again until $fx is equal to $ct.

I intend to use a while loop and read in these postings of four variables
until my requirement is met. Do I have to open the SQL database and write in
the four values for each passing of the loop? Or is there a way of storing
the values and writing in everything at the same time.

This is the code so far...

<?php

$ct=$_POST['totalnum'];

$fx = 1;
$insql1=$_POST["fardvag$fx"];
$insql2=$_POST["fornamn$fx"];
$insql3=$_POST["efternamn$fx"];
$insql4=$_POST["postnum$fx"];
$fx++

(I would like to "while" loop here until $fx=$ct, but don't see how I can
get the values into variables to be written to the database. As for each
passing of the loop new values will be assigned to each variable)

mysql_connect("localhost", "myusername", "mypassword") or
die(mysql_error());
mysql_select_db("my_database") or die(mysql_error());
mysql_query("INSERT INTO `animals` VALUES ('$insql1', '$insql2', '$insql3',
'$insql4')");
Header("Location: http://www.mydomain.com/");

(I can "while" loop here until $fx=$ct, but that means opening the database
for writing several times)

?>

Any help greatly appreciated.

Garry Jones
Sweden

[Back to original message]