Need help how to copy data from one table to another!!!!

[Redlightpacket]

I have been stuck on this problem for a while and I really need some help. What my code does is it displays data on the screen and the user can click a link that has a id=1 or whatever id, which it's purpose is to use to save data to the from row 1 or whatever id number it is in the table and copy it to the users table. I'm kind of confused about using the $_GET and trying to copy the data to the database with id and stuff? What do I do????

 

 

<?PHP



include 'connectdb.php';

session_start();


$id = "";

///////////////////////////////////////////////////////////////////////////////
//Displays bible verses on the verse page.
$query = "SELECT * FROM publictb";

$result = mysql_query($query)
or die("Query failed: " . mysql_error());

while ($row = mysql_fetch_assoc($result))
{

echo'<table border="1">
<tr>
<td>';echo $row["idb"];echo'</td>
<td>';echo $row["scriptrefb"];echo'</td>
<td>';echo $row["scriptureb"]; echo'</td>
<td><a href="http://localhost/new_insert.php?id='.$row["idb"]. '">SAVE</a></td>

</tr>
</table>
';

}
///////////////////////////////////////////////////////////////////////////////

//Count the row to the database and insert the data to the user database
//Try to make a link from a button in php get function

 

[fenway]

Well, i don't see an insert statement... that might help.