-2

I want to get all unique "ID" from other Table. Sample Table "product_tb" unique column "ID", column "productname". Then i will create other table. Sample table "cart_tb" column name "cart_list". Database name sample "lazada_db".

What i want to happen is that, When i input in column name "cart_list" in Table "cart_tb" with and Array number for "list" that store all unique "ID" for "product_tb".

Question:

  1. how to query to "cart_list" to insert multiple "number" for "ID" in "product_tb".
  2. how to query to "cart_list" to get all information from "ID" in "product_tb" which also get the "productname".
SpicySandwich
  • 9
  • 5
  • i find the answer link https://stackoverflow.com/questions/17371639/how-to-store-arrays-in-mysql – SpicySandwich May 21 '22 at 15:02
  • Can you provide a data example ? that would make it easier for the comunity to help you. – Benjamin Breton May 23 '22 at 08:59
  • It is not very clear what you have written in English. Please try to provide some code lines that you have tried so far, maybe we can help you better. provide complete and clear examples of your tables and data types. – shila mosammami May 23 '22 at 13:04

0 Answers0