Hello, please I need help on how to use variables when using the IN of mysql. I.e "SELECT * FROM table_name WHERE username IN ('$username') ORDER BY DATE". Please is it possible to write it that way or is there a right way of writing that. Thanks for your help

Yeah, that's the perfect way. IN ('$username', $integer, ?)

Thanks for the assistance. I forgot to mention that the variable $username is coming from database holding an array of values separated by comma (,). For instance $username = "macwilcy,cy,cyril,cy1,macwilcy1,...";. I want to use the username to fetch post made by users ordering it by date. I initially used "SELECT * FROM table_name WHERE username = '$username' ORDER BY DATE" but it was fetching the posts starting from the first username to the last username regardless of which user's post is the latest post. I will very much appreciate your help. Thanks

//if $username = "macwilcy,cy,cyril,cy1,macwilcy1,...";
//Do this first

$username = str_replace(",", "','", $username);

//Therefore, $username is now = "macwilcy','cy','cyril','cy1','macwilcy1,...";


//Then, SQL Query
SELECT * FROM table_name WHERE username IN ('$username') ORDER BY date_posted DESC

#Happy Coding