[RESOLVED] insert using a loop

[chrispos]

I am using php 5 and mysql 5

I am looking to insert data using a loop The tables are day, month, year, price

When the form is submitted I have d d1 and I would like to put the data d month year and price.

The php code is as follows

$d = $_POST['d'];
$d1 = $_POST['d1'];
$num = $d;
while ($num <= $d1)
{
echo $num."<br />";
$num++;
}

This works great but has anyone any idea on how to insert this data using a loop so that the form is just pressed once.

Many thanks if you can help

[chrispos]

many thanks for taking a look I have solved it using the code below if it helps someone.

$d = $_POST['d'];
$d1 = $_POST['d1'];
include 'config.php';
for ($i = $d; $i <= $d1; $i++)
{
$query = "INSERT INTO `test`(`day`) VALUES ('$i')";
    $result = mysql_query($query) or die (mysql_error());
	echo "$i";
	}