Help with Query not returning

[dweb]

Hello

 

I'm using the following prepared statement code

$member_id = 43;
$lession = array("AA,BB,CC");
$lessions = "'".implode("','",$lession)."'";  
$prep_stmt = "SELECT COUNT(da.points) as points, da.user FROM data da WHERE da.memberid = ?  AND da.lession IN (?) GROUP BY da.memberid LIMIT 1";
$stmt = $database->prepare($prep_stmt);
$stmt->bind_param('ss', $member_id,$lessions);

for some reason its not working.

 

annoyingly, if I change it to

$member_id = 43;
$prep_stmt = "SELECT COUNT(da.points) as points, da.user FROM data da WHERE da.memberid = ?  AND da.lession IN ('AA') GROUP BY da.memberid LIMIT 1";
$stmt = $database->prepare($prep_stmt);
$stmt->bind_param('s', $member_id);

then it works fine

 

so i have figured its to do with the array im passing to

da.lession IN (?)

any idea how i can fix this so it works off my array

$lession = array("AA,BB,CC");

thanks

 

[gristoi]

$lession = array("AA,BB,CC");

 

should be

$lession = array("AA","BB","CC");