[group-concat] Forum Topics

Hello, so I was trying few relations between tables and I noted an unexpected behaviour when using `group_concat()`. Let say I have three tables: fruits, fruitstock and fruitprices. These are the structures: create table fruits ( id tinyint unsigned not null auto_increment primary key, name varchar(50) not null, quality varchar(50) …

Hi All, Firstly I will say that this exercise is for my learning experiences through an online course. However I have spent a combined total of about 6 hours working on this question and I am completely stumped on how to get the correct answers. The question: > List the …

how to convert install_amt to comma delimited array $select = mysql_query("SELECT ac_no,cust_name,install_amt,GROUP_CONCAT(install_amt) FROM ankali_slabpay WHERE agent_id=$agent_id GROUP BY ac_no"); $a=array(); while($row1 = mysql_fetch_assoc($select)){ $installment = $row1['GROUP_CONCAT(install_amt)']; $a=explode(",",$installamt);