Gmunky Posted December 13, 2006 Share Posted December 13, 2006 hello. I was wondering if anyone knows a good way to write a query when you have a list of primary keys. for intance, if I have a table 'User' with id (primary key) ,fname and lname for the attributes, and I want to print out the fname and lname of all the users that matches my array of ids.id[array] = (1,2,3,4,5,7,etc.) // i want to print out the names that have these idsUSER--------id | fname | lname------------------1 bob barker2 jo blo3 james blunt4 .. ..5 .. ..6 .. ..7 .. ..thank you for all your help! Quote Link to comment Share on other sites More sharing options...
artacus Posted December 13, 2006 Share Posted December 13, 2006 Implode your array into a string then use.SELECT *FROM user WHERE id IN (1,2,3,4,5,7) Quote Link to comment Share on other sites More sharing options...
fenway Posted December 15, 2006 Share Posted December 15, 2006 And quote your IN() values for good measure. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.