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! Link to comment https://forums.phpfreaks.com/topic/30429-writing-a-query-from-an-array-of-ids/ 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) Link to comment https://forums.phpfreaks.com/topic/30429-writing-a-query-from-an-array-of-ids/#findComment-140167 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. Link to comment https://forums.phpfreaks.com/topic/30429-writing-a-query-from-an-array-of-ids/#findComment-142103 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.