PHP LOOP from database and save into one field

Question

I need some help.

I have table one with field code and table two with field code_two.

record from table_one :

----code----
32
23
34
25
------------

and send to table_two like this

----code_two-----
32,23,34,25.
-----------------

I want to send record from table one field 'code' into table two field code_two.

Here my php loop input box

foreach($_POST['code'] as $cnt => $qty) {|
    mysql_query("insert into table_two values('$code_from_table_one');
}

is that loop in query is work? I tried and getting error, little help please.

You could take all the values from the first query into an array and use the implode() function, that way you only need to run one insert. — llanato
– llanato, Commented Sep 26, 2014 at 10:09

Robert · Accepted Answer · 2014-09-26 10:12:30Z

2

Don't need to use PHP for it you can do it with GROUP_CONCAT() in MySQL

INSERT INTO code_two SELECT GROUP_CONCAT(`code` SEPARATOR ',') FROM code

answered Sep 26, 2014 at 10:12

Robert

20.3k6 gold badges58 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

simple solutions are the best :) my friend