Hi there. I'm looking to select certain rows from one table and add the selected rows to another table using checkboxes. I Have had limited success adapting some code for deleting multiple records using checkboxes.

At the moment all the records are added even if i only check one checkbox, which is progress but not exactly what i'm looking for.

Here's what i have so far

<?
$host="localhost"; // Host name 
$username="UN"; // Mysql username 
$password="PW"; // Mysql password 
$db_name="DB"; // Database name 
$tbl_name="test_mysql"; // Table name
$tbl_name2="test_mysql2"; // Table name
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
// Count table rows 
$count=mysql_num_rows($result);
<?php
while($rows=mysql_fetch_array($result)){
?>
......
<tr>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="y" /></td>
<td align="center"><input name="name[]" type="text" id="name" value="<? echo $rows['name'];?>"></td>
<td align="center"><input name="lastname[]" type="text" id="lastname" value="<? echo $rows['lastname'];?>"></td>
<td align="center"><input name="email[]" type="text" id="email" value="<? echo $rows['email'];?>"></td>
</tr>
.............
<?php
}
?>
<input type="submit" name="Submit" value="Submit">
<?php
// Get values from form 
$name=$_POST['name'];
$lastname=$_POST['lastname'];
$email=$_POST['email'];
// Check if button name "Submit" is active, do this 
if($checkbox){
for($i=0;$i<$count;$i++){
$sql1="INSERT INTO $tbl_name2 (name, lastname, email)VALUES('$name[$i]', '$lastname[$i]', '$email[$i]')";
$result1=mysql_query($sql1);
}
}

i realise i somehow have to get the selected checkboxes into the loop, but have drawn a bit of a blank.

Any help much appreciated

Mat