Copying data to database table question???

[Redlightpacket]

 

I want to be able to click on an item and save it a table in a database or insert it into the table. How do I get the data to be saved from the mysql_fetch_assoc results to a table in a database.

Below is some sample code to help you.

$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['username']. '">SAVE</a></td>
  </tr>
</table>
';

[premiso]

You wild use a MySQL insert and or Update statement...but you are pulling it from the DB...is it not already saved to a table?

[Redlightpacket]

thanks for the help pedro!

That helped