loading...

re: Best way to store array type data inside database? VIEW POST

TOP OF THREAD FULL DISCUSSION
re: 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

image

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.

code of conduct - report abuse