Let's say I had a table similar to this (named items):
itemNum | price
1234 | 34.95
2533 | 19.95
2144 | 21.95
2185 | 74.95
What is a good way to get, for example, the prices of items 1234 and 2144? Do I need to run two queries, like this?
SELECT price FROM items WHERE itemNum = $itemOne
SELECT price FROM items WHERE itemNum = $itemTwo
Or, is there a better way?
Sorry for the "newbie"-ish questions.
Thanks!
Jason