CODEWITHSUNDEEP
phpmysql
malv
malv

Reputation: 39

Group_Concat wont work

When I try this code on phpmyadmin it works

$results=mysqli_query($db,"
SELECT a.id
     , f.titulli
     , f.cmimi
     , GROUP_CONCAT( Concat(x.emri,x.mbiemri ) SEPARATOR "," ) AS Aktori
  FROM aktfil a
  JOIN filmat f
    ON a.id=f.id 
  JOIN aktoret x
    ON a.idakt=x.idakt
 GROUP 
    BY f.titulli") or die(mysqli_error($db));

But when I write on.php it says this Warning: mysqli_query() expects parameter 3 to be integer, string given in C:\xampp\htdocs\lab\betterdisplay\serverbetterdisplay.php on line 10

Upvotes: 1

Views: 30

Answers (1)

malv
malv

Reputation: 39

The right code thanks to @Uueerdo 

$results=mysqli_query($db,"SELECT aktfil.id, filmat.titulli, filmat.cmimi, 
GROUP_CONCAT( Concat( aktoret.emri,aktoret.mbiemri ) SEPARATOR ',' ) AS Aktori 
FROM aktfil JOIN filmat ON aktfil.id=filmat.id JOIN aktoret ON aktfil.idakt=aktoret.idakt
GROUP BY filmat.titulli") or die(mysqli_error($db));

Upvotes: 1

Related Questions