select from database where criteria matches array

[usgoel]

I have an array (say $arr) containing all the valid ID's.

I want to pull records from mysql where the id-field of mysql table matches from the array range. How do i do this????

eg.
$arr=array(5,12,19,23,68,98);

Now,
I want to pull records from mysql table (tablename Personal) whose personal_id is present in $arr.

$arr do not actually have fixed values neither in value nor in no.

So, How to do this????

Regards.

[laserlight]

You probably want to construct a query such as this:
SELECT * FROM Personal WHERE personal_id IN (5,12,19,23,68,98);

You would likely use [man]implode/man on $arr to achieve this.

[usgoel]

Thanks laserlight !!

Had never hoped that solution was toooo simple.

Thanks again for your help