php - Complex SQL Query Returning Duplicate but varing Values even with key word DISTINCT -

-

Based on the following query I just need to return two sets of data, but I get four instead < / p> 

  SELECT DISTINCT *, CASE WHEN likes.face_id = persona.face_id then liked '1' ELSE '0' END, case when dislikes.face_id = persona.face_id then '1' or '0 'End dislike, case when comments .face_id = persona.face_id then' 1 'ELSE' 0 'END tags the person, likes, dislikes, comments commented, tag tags tagged on the tag. Phone_id = 'fa' ou persona.face_id = tag. Face_id   
 are the following tables I  
 Inquired from the tagged table:  
 
  Phone_Image Face_id such as discounted discount comment comment FA GA 1 1 1 FA SA 1 0    
 Personality table:  
 
  The name of the face_id is GA frank 34 SA mark 24    
 Preferences table:  
 
  face_id phone_ id GA FA SA FA    
 Dislikes table:  
 
  Face_id f Note_FAQ    
 Comment table:  
 
  face_id phone_id comment GA FA good    
 I get four values ​​(four sets of data) from the above query instead of two (two set of data) values ​​ 
 The data given above is the result of the above query "1", " dislikeCount ":" 1 "," commentCount ":" {0} "data": "{" "face_id": "GA", "likeCount": "1", "dislikeCount": "php  
 
 {"face_id": "SA", "lik "0", "comment": "0", "commentCount": "0", "name": "frank", "age": "24", "likes": "0", "comment" : "1", "dislikeCount": "1", "commentCount": "0", "dislikes": "0"},  
 {"face_id": "GA", "likeCount": "1", "dislikeCount" "1", "name": "34", "likes": "0", "commented,": "1", "dislikes": "0", "0" , "0", "commented", "frank", "0", "0", "1"},  
 {"face_id": "SA", "likeCount": "1", "dislikeCount" "0", "dislikes": "0"}}}   P> 
 
 A more general approach  
  SELECT *, CASE WHEN, like .face_id = persona.face_id THEN '1 Likes' ELSE '0' END, Matters When in dislike.face_id = personality.face_id then dislikes the '1' or '0' end, the comments where comments.face_id = tag.face_id then added '1' or '0' comment from the comment commentary person .face_id = tag .face_id LEFT JOIN likes .face_id = persona.face_id and likes. Phone_id = 'FA' Skip Dislikes on Dislikes .face_id = tag.face_id and Dislikes. Phone_id = Join the comment on 'FA' comment Face_id = tag.face_id and comments.phone_id = 'fa' where was tagged. Phone_id = 'FA'   
 But there is a problem, all face-in-the-eyes come out as

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: 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

php - How can I cram 6+31 numeric characters into 22 alphanumeric characters? -

-
I have a 6 digit number and a 31-digit number (such as "234536" and "201103231043330478311223582826") that I The API needs to be crawled in the same 22-character alphanumeric field that uses PHP. I tried to convert each one to 32 (using custom code could not handle the base_convert () large number) and to connect with a single-character delimiter, but It only gives me 26 characters This is a restore API, so the letters should be URI-protected. I would like to do a database table cross with two references without reference to another reference value, if possible, any suggestions? Instead use a radix of 62. This will give you 22 characters for the top, 3.35 for the pre and 17.3 for the next. & gt; & Gt; & Gt; Math.log (10 ** 6) /math.log (62) 3.3474826039165504 & gt; & Gt; & Gt; Math.log (10 ** 31) /math.log (62) 17.295326786902177
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