mysql - SQL get friends from friends table by username -

-

Okay, I'm stuck with the table design which I can not change now and I'm going to get the username Based on the relationship table between all your friends in relation to friends

What I have now: 

  select different (user name) from members. Join the internal member at f.id_memb_friend1 = m.id. I F.id_memb_friend1 = 173 or f.id_memb_friend2 = 173)   
 The members table has columns: id, use In the name of the member name mailer, the column ID, id, id_memb_friend1, id_memb_friend2  
 query has returned the user's name to the user name ID 173 which is the owner and for example, his nickname is magnificent. Based on the username that I provide (Great = ID 173), all the friends have to meet together with the user name.  
 Update:  
 I want to receive it:  
 Input: Username = Great actions: Get names of great friends (with their ID) Output:  
 members.id = 5 user name = John  
 subscribers .id = 15 user name = Lara  
 members.id = 66 username = Alex  
 and so on ...   
 
 
 (new requirement expressed in comments Up to adjust (Updated to accommodate the new requirement expressed in the updated question.)  
 Your question (s) was incompatible with whether you have a username or user ID Want to search on the basis. Although your query uses ID, I use the username as per the specification. I also believe that you want the  friend  'username (only) In addition, this seems like your initial query that you want to see the relationship in both directions (display on match 1, show all friend 2, and match on friend 2, show all 1 friend).  
 Here's one of the ways that:  
  select mm.id, mm.us member member from m.m. Join F_id_memb_friend1 = Member at mm.id. MIID = Internal member at f.id_memb_friend2 where I select the user name = 'brilliant' union mm.id, mm.us member member from mm. Interval can include f.id_memb_friend2 = mm.id at m.id = f.id_memb_friend1 mid = m.username = 'splendid'

Comments

Post a Comment

Popular posts from this blog

php - PDO bindParam() fatal error -

-
I am trying to learn PDO, now I have written this small code, but it gives me a serious error: < P> Fatal error: Call a member function at a non-object dot () ... $ con = new mysqli ("127.0.0.1", "root", "", "csvdangercheck"); $ Query = $ con- & gt; ("Id,` var1`, `var2`) values ​​(" id,: var1,: var2) ";); $ query- & gt; bypass pattern (': id', $ id); $ query- & gt; BindParam (': var1', $ VAL1); $ Query- & gt; bindParam (': var2', $ val2); $ Query-> Executed (); I Trying to use print_r ($ con-> errorInfo ()) but Fatal error: Undefined method mysqli :: errorInfo ( ) ... can someone tell me what am I missing? Flaffeh said, you have PDO Missing Mysqy, try it: $ con = new PDO ('mysql: host = 127.0.0.1; dbname = csvdangercheck', 'root', '');
Read more

logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

-
For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i
Read more

java - Why my included JSP file won't get processed correctly? -

-
I am trying to create Java web framework (and learning), and on the basis of 'Code Generator In the process of making the material view of the database in the process of development, I stumbled into a difficulty, which I do not know how to solve it. First of all, I want the following index.jsp : & lt; Body & gt; Use all pages to be created. & Lt;% @ include file = "header.jsp"% & gt; & Lt; Hours / & gt; & Lt;% @ included file = "body.jsp"%> & Lt; Hours / & gt; & Lt;% @ include file = "footer.jsp"% & gt; & Lt; / Body & gt; And, in body.jsp , I should have it like this: & lt; Jsp: include page = "$ {Application_modul}"%> Where application_modul is an attribute defined in its controller: request.setAttribute ("application_modul", "USER_ACCOUNT \\ ' View_user_account.jsp "); This file can be found properly, but the processed JSP does
Read more