forum

home / developersection / forums / php - mysql move records from table to other table

Ask Question

php - mysql move records from table to other table

Hank Greenberg 2899 09-Jul-2013
Hi Mindstickians,

I want to insert a record from first query i means the rows make then with seconds query to insert. can some one help me please

if ( isset($_GET['del']) ) {
    $id = $_GET['del'];
    $result = mysqli_query($con,"SELECT * FROM products WHERE id='$id'");
    while($row = mysqli_fetch_array($result))
    {
        echo $row['username'] . " " . $row['size'];
        echo "<br>";
    }
    $sql_move = mysqli_query($con,"INSERT INTO history (username, serial, image,   arrive,size)");
    $sql = mysqli_query($con,"DELETE FROM products WHERE id='$id'");
    echo "its deleted";
}
?>

Thanks in advance.
php php 
Updated on 09-Jul-2013
Hank Greenberg

Other

Follow
Can you answer this question?
Answer

1 Answers

AVADHESH PATEL

AVADHESH PATEL

09-Jul-2013
Try as following!

First of all, you're trying to access $row from outside the loop, where it doesn't exist. Put the insert/delete lines in the loop, and then proceed.

Second, you're not inserting the values.

$sql_move = mysqli_query($con, "INSERT INTO history (username, serial, image,   arrive,size) VALUES ('{$row['username']}', '{$row['serial']}', '{$row['image']}', '{$row['arrive']}', '{$row['size']}'");
MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy