Inserting values to another table

[raouleduke]

I am trying to create a donot call list , I have this form, and I want to only submit the ones that remove are checked into another database

mysql_connect("","",""); 
	mysql_select_db(""); 
	$query = "SELECT * FROM $catagory$subcatagory WHERE ACTIVE = '1' GROUP BY CUSTNO ORDER BY CUSTOMERNAME ASC";
	$result = mysql_query($query);
	echo "<form method='post' action='submitdata.php?subcatagory=$subcatagory&donot=custno'>";
	echo "<table border=2 bordercolor=#5E3964>\n";
	echo "	<tr>
			<td><font color=#800303>Remove</font></td>
			<td><font color=#800303>Name</font></td>
			<td><font color=#800303>Customer #</font></td>
			</tr>\n";
	while ($currentrow = mysql_fetch_array($result)) {
	printf("
	<tr>
	<input type='hidden' name='CUSTNO[]' value='%s'>
	<td><input type='checkbox' name='REMOVE[]' value='1'></td>
	<td><font color='#000066' size='2' face='Verdana, Arial, Helvetica, sans-serif'>%s</font></td>
	<td><font color='#000066' size='2' face='Verdana, Arial, Helvetica, sans-serif'>%s</font></td>
	</tr>\n",

$currentrow["CUSTNO"], 
$currentrow["CUSTOMERNAME"],
$currentrow["CUSTNO"]
);
}
echo "</table>";
echo "<input type=submit name=submit value=Submit>\n";
echo "</form>";

Here is the submit page.

$donot = $_REQUEST['donot'];
$VIN = $_POST['VIN'];
$CUSTNO = $_POST['CUSTNO'];
$REMOVE = $_POST['REMOVE'];



mysql_connect("","",""); 
mysql_select_db("a0020386"); 
if($donot == 'vin'){
if($REMOVE == '1'){
$query = "INSERT INTO LUTHERSELLANDRECOMMENDDONOTVIN SET VIN='$VIN'";
print $query."<br />"; 
$result = mysql_query($query) or die(mysql_error());
echo"Thank You! Information {Updated.\n";
print "<meta http-equiv=\"refresh\" content=\"1; URL=activedata.php?subcatagory=RECOMMEND\">";
}
}

Thanks in advance.

[sidney]

your insert should look more like this depending how many fields you have in table you will need to and field names and values seperated by ,

"INSERT INTO LUTHERSELLANDRECOMMENDDONOTVIN (vin) VALUES ('$VIN')"

[planetsim]

There is nothing wrong with the Insert Query. I suggest taking the $result off the insert query though.