selecting data from one mysql table and insert into another table

Asked Jan 31 '17 at 16:39

Active Jan 31 '17 at 16:58

Viewed 17 times

    <?php
mysql_connect("localhost","root","");

    mysql_select_db("inventory");
    $data=mysql_query("SELECT product_name, cp FROM product WHERE qty=0");
    $rec=mysql_fetch_row($data);

    if(mysql_query("INSERT INTO outofstock (product_name, quantity) VALUES ('$rec['product_name']', '$rec['qty']')"))
    {
        echo "Added";
    }

?>

when i run this i get this error->

syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in C:\xampp\htdocs\inventory\outofstock.php on line 8

edited Jan 31 '17 at 16:58

Option

2,605
2
19
29

asked Jan 31 '17 at 16:39

4M01

mysql_* is now deprecated you should learn either mysqli or pdo. – Option Jan 31 '17 at 16:39
can be done in one `INSERT INTO outofstock SELECT product_name, cp as quantity FROM product WHERE qty=0` – JustOnUnderMillions Jan 31 '17 at 16:41
And the error comes from `'$rec['product_name']'` change it to `'{$rec['product_name']}'` and on all other variables – JustOnUnderMillions Jan 31 '17 at 16:42
but it is fetching values from table product but problem is in second query i guess – 4M01 Jan 31 '17 at 16:47
it worked thank you so much..:) – 4M01 Jan 31 '17 at 16:53

selecting data from one mysql table and insert into another table

0 Answers0