looping mysql query to get multiple rows of data from a table and insert into another table

debugcn Published at Dev

user3620142

I am working on a small project and is having some issues with looping MySQL insert. I currently have 2 database tables. I am fetching information from one to another.

table with data:

$q = "SELECT * FROM HARDWARE WHERE ID_2=".$db->qstr(20);
$rss = $db->execute($q);
$re2=$rss->GetArray();

so I am getting the array of data fine.

inserting the data only if the id is {20} Currently I have 2 rows with ID_2 = 20 but it is only inserting one row not both. here is my insert query.

$sql = "INSERT INTO PARTS SET
          IN_ID     =". $db->qstr($in_id).",
      ER_ID     =". $db->qstr( $er_id).",
      ITEM      =". $db->qstr( $re2[0]['ITEM']   ).",
      NAME      =". $db->qstr( $re2[0]['NAME']   );

it inserts the data fine, just one row not multiple rows. any suggestions?

Thanks.

Marius.C

Insert your query in a loop

foreach ($re2 as $r): $sql = "INSERT INTO PARTS SET IN_ID =". $db->qstr($in_id).", ER_ID =". $db->qstr( $er_id).", ITEM =". $db->qstr( $r['ITEM'] ).", NAME =". $db->qstr( $r['NAME'] ); endforeach;

or use multiple inserts Inserting multiple rows in mysql

both should be fine at what you have there.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-06-27

Comments

0 comments

From Dev

Related Related

Article

looping mysql query to get multiple rows of data from a table and insert into another table

looping mysql query to get multiple rows of data from a table and insert into another table

insert multiple rows mysql from another table

How to insert multiple rows from a table to another table based on date condition (PHP-MySQL-Query)?

Insert multiple rows with single a query from one table into another in Oracle

MySQL - Insert table data from another table

MySQL - Insert table data from another table

Insert multiple rows from select into another table

Insert multiple rows into a MySQL database from a table

Mysql query insert from another table

Mysql insert into with multiple id from another table

Insert (multiple) new rows into a table from another table using a subquery?

MYSQL - UPDATE multiple rows from another table

MySQL query - single row in one table with multiple rows in another table

MySQL insert into column data from another table

Insert Data From One Table To Another - MySQL

Insert new rows into table but copy data from another row in the table

Mysql query to get rows of a table as columns of another, with column names from third table

Select multiple columns from a table and insert data into another table in a different database in PHP-MySQL

Update MYSQL Table from multiple rows in another table

select multiple column from one table and insert into another as rows

SQL insert multiple rows from single field in another table

INSERT rows multiple times based on a column value from another table

Insert rows into a table from another two tables separately in mysql

Insert Data from one table to another leaving the already existing rows

Select from multiple tables, insert into another table Oracle SQL query

Hibernate HQL query get data from table associated with another table

MySql Retrieving Data from multiple Tables then Insert limited values In another table

SQL insert data into a table from another table

SQL insert data into a table from another table

Multiple insert in MySQL table from PHP table