Select From Issue

[Shit4Brains]

Am i being a tard or what....

i have a big fat array of id's (ints)...

i want to select all of them from the database and then print out some info from each record in the db.

geddit?

the deal is, i have a search engine....which returns all the records which are relevant. it only returns their ID's.

$results_array = performSearch($sort_by, $exact_search, $search_where, $search_keyword);

then the page changes...blah blah....&& i then want to list all the records with those i'ds from the array.

any ideas? BUT i dont want to use a loop. i wanna do it within 1 sql query if possible.

Thanks

[laserlight]

Are you looking for something along the lines of:
SELECT * FROM tablename WHERE id IN (1, 2, 3, ...);

the 1, 2, 3, ... part can be obtained by [man]implode/maning the array.

[Shit4Brains]

ahh, yes.

i didnt know about 'IN'. i only ever used WHERE blah=1

so if i use WHERE blah IN (1,2,3,4)

it sud work..

[Shit4Brains]

SELECT * FROM qst_logbook WHERE log_id IN ('1','2','3')

thats the sql....its returning no results tho. & i definately have records with the log_id's of 1 2 and 3...so it sud return 3 rows.

[stevesweetland]

can you output db_error and see if anything comes up? print your sql to screen, and chuck it into a phpmyadmin sql window to test it, if it works its your code, if it doesnt work, phpmyadmin will tell you whats wrong with the sql.

IF that really is the sql statement you have, then it looks about right, and it must be a code problem you have.

[Shit4Brains]

i found the problem, i forgot i didnt 'empty' the db. so the id's didnt revert back to 0, 1 2, etc..they were still on 72, 73, 74..... lol...my bad.

works a charm!