php - Having some trouble with a mysql query pulling data from multiple tables... logic question -

php - Having some trouble with a mysql query pulling data from multiple tables... logic question -

Ill try to keep this simple and point-to-point basically I have news feeds and a comment section. There are two levels in the section of the comments: responses and then responses to responses. Originally structured like a special newsletter:

  -> Comment --- & gt; Answer --- & gt; Answer:    There may be many answers in each comment, obviously for doing this, to answer incorrectly, you have to do an SQL query for each comment and to list them.  Edit  Comments have only 1 response level, that is, can not answer the answers. - Thanks Johnp  
 My questions for this kind of query:  
 Should I have comments and answers in different tables and should use a join, or do I answer Can I keep comments and use the qualifier to separate the same table and type?  
 Should I try sorting them using the query or drag all the data into an array and sort? Display this way?  
 My table currently is as follows:  
  ID (unique, auto increment) NEWS_ID (comment on a special news post is concerned) REPLY_ID (if any If there is an answer to another comment, please comment on a parental comment) USER_ID BODY PUBLISHED_DATE    My suggestions will be highly appreciated by those wise people! I am still in the initial stages of fully understanding JOINS and other high level MySQL query structures. (IE: I have to suck on my SSX, but learning IIM :)   
 
  Since you have replied that One level is deep ..  
 I can create comment 1 table and link a  comment_id  field and link a  news_id  field to news item To show. In this way you can simply query for all comments that match  news_id  and sort it by  comment_id . And then a small fraction of PHP array magic will give you a sorted list of comments / answers.  
 So take a look at your current table, you are on the right track.   

 


  







03:22

















Get link





Facebook





X





Pinterest





Email





Other Apps

Comments Post a Comment

Popular Posts r - Plot correlation matrix into a graph - I have a matrix with some correlation values. I now want to plot in that graphic which is more like this or Looks less: Library (Latis) # Horizontal and vertical axis information please take- c (div class = "post-text" itemprop = "text"> "214", "215", "216", "224", "211", "212", "213", "223", "226", "225") & lt; - Paste ("DM1- ", Hor, sep =" ") # counterfeit co Relation matrix narokol & lt; (I 1: nrowcol) for core [i] - length (var) core & lt; - matrix (runif (nrowcol * nrowcol, min = 0.4), nrow = nrowcol, ncol = nrowcol (Color, "blue", "yellow"), space = "RGB"), levelplates (core, main = "dimnames = list (hor, ver)), I] = 1 # plot rgb. Stage 12-14 array correlation matrix ") Xlab =" ", ylab =" ", col.regions = rgb.palette (120), cut = 100, at = seq (0,1,0.01)) ... asp.net - RegisterUser: CreateUserWizardStep - When using CreateUserWizardStep to register a new user I'm having a problem. Help me solve this problem.I have tried to configure in the web. Provider tag for configuration & lt; Required question and answer = "wrong" & gt; Although it still does not work ... I'm using the MySQL database RegisterUser :. An IEditableTextControl is not included with the CreateUserWizardStep.ContentTemplate ID question for the security question, it is necessary that your membership provider needs a question and answer. Source error: An unrestricted exception occurred during the execution of existing web requests. Information about the origin and location of the exception can be identified using the exception stack trace below. Stack trace:. [HttpException (0x80004005): RegisterUser: CreateUserWizardStep.ContentTemplate does not include questions IEditableTextControl security question with the ID, it is necessary to require a question and answer your subscri... Integrate flash games in android app? - 3 is a flash game that I want to integrate into a menu / list in the Android app. So when the user selects the game from the list, the game starts with the help of the Android Flash Player. Is it better or better with webwave? Is there any good tutorial? Thank you! Adobe Flash provides a good way: you can create a breeze for the Android app. Use this to create your menu and compile three games in your air app. Here are some tutorial links about how to publish AiI for Android applications and: PART1: AIR for Android, PART2: Publication for Android apps: Ai: I do not believe that the Android Flash Player can be launched with a single intention so far, so using Java Android will not solve it (now ) And and a third approach Whatever you mentioned, it should work - using the webwave.

Powered by Blogger