[conmen80]

Hi all, I need help in php program.

Below is a html table which load all related data records selected by SQL query from table_A (assume it was a temporary table), I want those related temporary data to insert into another table, which named table_B in the database, after the insertion to table_B, all related data from table_A will delete, how can I accomplish it?

Lets say below html table has success load 20 records from table_A, after the authenticated of all data is correct, will submit and insert into table_B, those 20 records will remove from table_A once successful added to table_B.

PHP Code:

while($row = mysql_fetch_array($result)){
    $data1 = $row['data1'];
    $data2 = $row['data2'];
    $data3 = $row["data3"];
    $data4 = $row["data4"];
    $data5 = date('d M Y', strtotime($row["data5"]));
                            
$str = "<tr>                                        
            <td class='list'><div style='margin:0 5px 0 5px;'>$data1</div></td>
        <td class='list'><div style='margin:0 5px 0 5px;'>$data2</div></td>
        <td class='list'><div style='margin:0 5px 0 5px;'>$data3</div></td>                
        <td class='list'><div style='margin:0 5px 0 5px;'>$data4</div></td>
        <td align='center' class='list'>$data5</td>
        </tr>";
                        
echo $str; 

It is too long to get stuck on this part on my program, hope can find a best solution right here and the program can get through for further develop.

Thanks!!

[mdhall]

Why not just run a simple truncate/delete query on table_a after the data is added into table_b?

PHP Code:

$del = "TRUNCATE TABLE table_a"; 

[conmen80]

This is what i thought, thanks mdhall.