what;s the best way too.....

I have a piece of code which looks in a db based on a query and shows the info.

now what I want to do is have serveral of these
each pulling a different value.

example

say I have a db of books.
I want to show a bit about each book of a certain category.

I have 10 boxes on the screen, each one holds the info about one book. BUT each bit has it's own query.

What is the best way to have a master query then have the child queries get there results from that?

create a dummy db, use some kind of built-in transaction type deal or something else?

Thanks

Well, if you have a query like this

SELECT * FROM books WHERE id=12

just change it to

SELECT * FROM books WHERE id IN (12,15,192,4300)

which will return the 4 books. If you have some different arrangement of your tables, please post the details..