Moving data from one table to another

zzz

I have a page that draws an HTML table with a data from db_TBL1. I put a button on each row next to each line of data. I would like to be able to click that button and accomplish 3 things:

remove data row from db_TBL1
enter this very data into db_TBL2
Draw another table on the same page with data from db_TBL2 right after the first table that gets data from db_TBL1

I run into several problems: I am able to display table 1 but get bunch of errors for table 2...

What's the nice and easy way of accomplishing this.

kevinsequeira

if you could post the existing code, we could suggest how you can go about doing what you want

reg
kevin

zzz

Great idea. Here's what I have at the moment:

Innitial page thad displays the original results with a button next to it to push data to another table:

<?
$query = mysql_query("SELECT username FROM TBL1 where memID = '$memID'");
list($username) = mysql_fetch_row($query);
?>
...some page content...
HISTORY [<? print $username ?>]
<table>
<?
$result = mysql_query("SELECT * FROM TBL1 where memID = '$memID'");
$query = mysql_num_rows($result);
mysql_close();
while ($myrow = mysql_fetch_row($result))
{
printf("<form method=POST action=\"process.php\"><input type=hidden name=memID value=\"memID\"><tr><td><input type=submit value=\"Process\"></td><td>%s</td><td>%s</td><td>%s</td></tr> <input type=hidden name=val1 value=". $myrow[1] . "><input type=hidden name=val2 value=". $myrow[2] . "><input type=hidden name=val3 value=". $myrow[3] . "></form>\n",
$myrow[1], $myrow[2], $myrow[3]);
$total += $myrow[4];
}
?>
</table>

process.php page:

<?
$update = ("insert into TBL2 values ('$val1', '$val2', '$val3', '$memID')");
$update = ("delete from TBL1 where val1 = '$val1'");
mysql_query($update);
?>

I think that's it...

kevinsequeira

<?
$update = ("insert into TBL2 values ('$val1', '$val2', '$val3', '$memID')");
$update = ("delete from TBL1 where val1 = '$val1'");
mysql_query($update);
?>

u havent executed the query for the insert command

do this ..
<?
$update = ("insert into TBL2 values ('$val1', '$val2', '$val3', '$memID')");
mysql_query($update);
$update = ("delete from TBL1 where val1 = '$val1'");
mysql_query($update);
?>

reg
kevin

zzz

Great. Works now. One more question though. If I want to get back to the first page associated with that username or memID how do I do that.

Shall I add a line of code after I process the query?..

kevinsequeira

after

<?
$update = ("insert into TBL2 values ('$val1', '$val2', '$val3', '$memID')");
mysql_query($update);
$update = ("delete from TBL1 where val1 = '$val1'");
mysql_query($update);
?>

add this

<?php
header("location:initial_page.php?memID=$memID");
?>

reg
kevin

zzz

You rock!

this exactly what I needed

zzz

works