select query for array of ids mysql

by Ramya 2014-03-05 15:10:45

select query for array of ids mysql :


Sometimes, you need to fetch ids in an array format and select the fields from table based on those ids. For this case, you need not write for/foreach loop, get ids one by one and select the fields based on it.....

Just use MySQL "IN" statement to get all those ids in array,
$dispRun = 'SELECT * FROM WHERE id IN (' . implode(",", $passArrId) . ')';



This saves your time, line of code and get rid of looping concept to fetch the array of ids mysql.

Razz
Razz
510
like
0
dislike
0
mail
flag

You must LOGIN to add comments