"MySQL Query" query ;-)

I've got a loop in my script that will find out a bunch of ID numbers, each of these numbers will need to be queried and the results pulled out of the database.

I could put a seperate query within each each loop to get the results, but this has two problems, first one is that it will create way too many queries on that page (up to 30 un-needed extra queries), and the second problem is that the results will be in reverse (because of the way the loop works, and the loop can't be reversed, that won't work).

what I promise to do insted is take all these ID, and run one query to get them all, and just have mysql put them into the order I want.

Problem is that I don't now what the query should look like

Below is an example of what I think it should look like to give you an idea of what I mean, maybe you can point me in the right direction?

SELECT * FROM table WHERE id = 8,4,2,1

(in this example I want it to pull id's 8, 4, 2 and 1)

Thanx

[Ninth Dimension]

BTW, just so you know, if this is going to make it any easier (I know it will for me) the results of the loop are going to be put into an array, i.e.

PHP Code:

$array[] = 8;
$array[] = 4;
$array[] = 2;
$array[] = 1; 


so if it can be worked so that the query uses the array i'd really apprechate it.

[Ninth Dimension]

I've just been talking to someone that suggested I used one of he two below, neither worked

"SELECT * FROM table WHERE id = 8 OR  id = 4 OR id = 2 OR id = 1"
"SELECT * FROM table WHERE id = 8 AND  id = 4 AND id = 2 AND id = 1"

please help :bunny:

[Xenon]

the or part is correct, be sure your table has an id column

[Ninth Dimension]

yes, it has an id column, the OR one is only returning one result.

[Ninth Dimension]

OK, you can hit me now, i was being a pratt, it's true that I did have an id column, but it was not the id column that wanted to call.

Lets put this down to the typo LOL

anyway, if anyone knows how to do this via an array, i'm still interested in finding out, cheers.

[TeddyBare69]

Have you tried this yet?

SELECT * FROM table WHERE id IN  ( 8,4,2,1 )

You can also add this to put them in order

SELECT * FROM table WHERE id IN  ( 8,4,2,1 ) ORDER BY id

[Ninth Dimension]

I learnt about that a few days ago, very userful indeed. Thank you.