MDanz Posted August 29, 2011 Share Posted August 29, 2011 I want a query where searching for 'dave', will display the top three rows. 'mike' and 'carl' both have the parentid of dave. So the three rows displayed will be the top three. +----+----------+------------+ | id | parentid| user +----+----------+------------+ | 1 | null | dave | 2 | 1 | mike | 3 | 1 | carl | 4 | 2 | rick | 5 | 4 | mike What type of query will accomplish this? A nested query? Link to comment https://forums.phpfreaks.com/topic/245987-help-on-query/ Share on other sites More sharing options...
MDanz Posted August 29, 2011 Author Share Posted August 29, 2011 nevermind , i used an left join Link to comment https://forums.phpfreaks.com/topic/245987-help-on-query/#findComment-1263329 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.