php - One Select statement for criteria of one column with multiple values -


i want make sql select statement selects multiple rows based on value of 1 column, have list of valid values match rows want select.

specifically, have list of user ids. want select entire row every row has user id in list (this list in php, , i'm making sql calls there).

my code far, looks this:

$list_of_ids = array(1, 5, 7, 23);//list of user ids want select. $query = sprintf("select * users user_id=?????", ????); 

how do this?

$ids = implode(',',$list_of_ids); $query = sprintf("select * users user_id in ($ids)"); 

Comments

Popular posts from this blog

ios - UICollectionView Self Sizing Cells with Auto Layout -

node.js - ldapjs - write after end error -

DOM Manipulation in Wordpress (and elsewhere) using php -