I created the users, post and ps tables. users - user, post - mail, ps - stored id users and post. But the problem is that I do not know with the help of what it is better to make the chosen one on html

Closed due to the fact that the question is not clear to the participants by aleksandr barakin , Ipatiev , Akina , andreymal , default locale on Feb. 13 at 8:51 am .

Try to write more detailed questions. To get an answer, explain what exactly you see the problem, how to reproduce it, what you want to get as a result, etc. Give an example that clearly demonstrates the problem. If the question can be reformulated according to the rules set out in the certificate , edit it .

  • 2
    Form the question again, it is not clear what you want. And for the connection of the tables do not need a third. If you just need to select the best posts, add a column there and check on it. - Ruslan Semenov

1 answer 1

make a table of favorites, store id users in it, id post.

when the user c id wants to see his favorites,

then we make a selection from the table of favourites all entries with id users, we get an id post, then we do a selection in the post table based on the id post from the favorites table.

  • one
    A join is made, not two samples in a row. - u_mulder