How to insert multiple values in a specific field in a table using mysqli? I am working on a project and I I have a scenario like this: I have many field in my table :

table_name : transaction_tbl
-id
-name
-description
-ref_number : text(datatype)


In my inserting here is my code:

 $sql = "INSERT INTO transaction_tbl (`name`,`description`,`ref_number`) VALUES ('$name','$desccription',$ref_number)";

if ($conn-&gt;query($sql) === false){
                    trigger_error('Wrong SQL: ' . $sql . 'Error: ' . $conn-&gt;error , E_USER_ERROR);
                }else {
                    echo "Successful ! Data is inserted in database ^__^" ;

                }


As the name itself ref_number or reference number, so there will be a time that I will have a lot of reference number,how can I let it insert if it will have multiple values? Thanks :)

UPDATES :

I want something like this :

name    description            ref_number
bag     to be use               10359435846 
                               05438547656
                               035848576
No.  Don't put multiple values in a column; make a new table:

Mapping table
-id -- same as the `id` in transaction_tbl
-ref_number
PRIMARY KEY(id, ref_number)


For your example, there will be 3 rows in this table for the 1 row in transaction_tbl.

INSERT INTO transaction_tbl (name, descripton) VALUES (..., ...)
$id = LAST_INSERT_ID()
INSERT INTO mapping (id, ref_number) VALUE ($id, '10359435846')
INSERT INTO mapping (id, ref_number) VALUE ($id, '05438547656')
INSERT INTO mapping (id, ref_number) VALUE ($id, '035848576')


One way of getting the output:

SELECT t.id, t.name, t.description,
       GROUP_CONCAT(m.ref_number) AS ref_numbers
    FROM transaction_tbl t
    JOIN mapping m  ON m.id = t.id
    GROUP BY t.id;