inserting multiple records

[raouleduke]

I think that I am missing something relatively easy,

<?
			  echo "<form method='post' action='submitdata.php'>"; 
			  for($i = 0; $i <20; $i++) { 
			  $callerid = rand(21, 22);
			  print "
			  <input type=hidden name='autonumber[]' value='$i'>
			  <input type=hidden name='CALLER_ID' value='$callerid'>
			  <input type=hidden name='dealercode[]' value='$dealercode'>
			  <table width='100%' border='0' cellspacing='0' cellpadding='0'>
			  <tr> 
                <td width='20%' height='33'><input name='BUSINESSNAME[]' type='text' size='20'></td>
                <td width='20%'><input name='CONTACTNAME[]' type='text' size='20'></td>
                <td width='20%'><input name='CONTACTPHONE[]' type='text' size='20'></td>
                <td width='6%'><input name='CUSTOMERTYPE[]' type='text' size='5'></td>
                <td width='12%'><input type='checkbox' name='SURVEY1[]' value='1'></td>
                <td width='12%'><input type='checkbox' name='SURVEY2[]' value='1'></td>
                <td width='8%'><input type='checkbox' name='SURVEY3[]' value='1'></td>
              </tr></table>";
             }
			 echo "<input type=submit name=submit value=Submit>\n";
			 echo "</form>";	
             ?>

submit form

 <?php
$autonumber = $_POST['autonumber'];
$dealercode = $_POST['dealercode'];
$CALLERID = $_POST['CALLER_ID']; 
$BUSINESSNAME = $_POST['BUSINESSNAME']; 
$CONTACTNAME = $_POST['CONTACTNAME'];
$CONTACTPHONE = $_POST['CONTACTPHONE']; 
$CUSTOMERTYPE = $_POST['CUSTOMERTYPE'];
$SURVEY1 = $_POST['SURVEY1']; 
$SURVEY2 = $_POST['SURVEY2']; 
$SURVEY3 = $_POST['SURVEY3'];

mysql_connect("","",""); 
mysql_select_db(""); 
$query = "SELECT CURDATE() FROM LUTHERSELLANDRECOMMEND LIMIT 1";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
$todaysdate = $row["CURDATE()"];
}	

for($i = 0; $i < count($autonumber); $i++){
$query2 = "INSERT INTO Thermo_King_temp VALUES ('$dealercode', '$BUSINESSNAME', '$CONTACTNAME', '$CONTACTPHONE', '$CUSTOMERTYPE', '$SURVEY1', '$SURVEY2', '$SURVEY3', '$todaysdate', '$CALLERID')";
print $query2 ."<br />"; 
$result = mysql_query($query2) or die(mysql_error());
print "Thank you information updated!\n";
}
?>

Thanks in advance

[Shrike]

Perhaps it would help if you said what the actual problem is. The following seems a little incorrect:

$query = "SELECT CURDATE() FROM LUTHERSELLANDRECOMMEND LIMIT 1"; 
...
$todaysdate = $row["CURDATE()"]; 
//perhaps:
"SELECT CURDATE() AS date ... "
...
$todaysdate = $row["date"];

[raouleduke]

when I print the query on the submit, I just get array in the value fields, I have done this before but never without an SELECT statement in front of it, I just want to insert blank new records into the database.

Thanks,

[Shrike]

Ah all of your HTML fields are getting submitted as arrays (name="name[]"). Either remove the square brackets from the names, or reference them in PHP as $POST['name'][index] e.g. $POST['name'][0].