To retrieve a post and all its tags, you need to JOIN the tables in your queries
On using the INNER JOIN clause it doesn't get the data if specific post have multiple tag_id
INNER JOIN
tag_id
SELECT * FROM post INNER JOIN tag ON post.post_id = tag.post_id;
it only return the data for 3rd row according to the above image.
INNER JOIN tag
Can you see the mistake here?
You need to do the JOIN with the post_tags table (with both references, posts and tags) to work.
Yeah I know that,
I tried with the both with and without post_tag table, it was return 0 rows.
post_tag
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
On using the
INNER JOIN
clause it doesn't get the data if specific post have multipletag_id
it only return the data for 3rd row according to the above image.
Can you see the mistake here?
You need to do the JOIN with the post_tags table (with both references, posts and tags) to work.
Yeah I know that,
I tried with the both with and without
post_tag
table, it was return 0 rows.