I am recently working this system with sql server, now i would like to swith with mysql for some reason. Ive got stuck in converting this line of codes to fit with mysql.. can someone give me a hand with this. here's the code:
$sql = "
select t1.request_id,t1.user_id,t1.user_name,t1.dept_desc,t1.DivisionCode,t1.status,t1.remarks,
STUFF((
SELECT ',* '+convert(varchar(50),asd.technical_id)+'***'+convert(varchar(50),asd.category_id)+'***'+ asd.technical_desc
FROM requesttechnical_tbl t2,technical_tbl asd
WHERE t2.request_id = t1.request_id and asd.technical_id=t2.technical_id order by asd.category_id desc
FOR XML PATH ('')),1,2,'') AS technical_desc,