如何将图像包含在图库中 - 包含在文章中[重复]

Question

This question already has an answer here:

• Is storing a delimited list in a database column really that bad? 10 answers

three tables - articles, galleries, images.

articles has a column gallery (integer - id of included gallery)

galleries has a column images (csv string - ids of included images)

images has id and src columns.

Now I need to get src of images -> included in a gallery -> included in an article.

I firstly select gallery id from the table articles

Then - using the given gallery id - select images ids from the table galleries

Then using the given images-ids - select the sources of images from the table images.

This scenario is tedious, requires a lot lot of coding.

Is there any shorter, easier way?

I cannot write img sources or img ids directly inside articles because need to get changes inside articles automatically - when a change inside galleries or images is done.

Any help?

</div>

Answer 1

use JOIN

$sql = 'SELECT a.id, a.column_name,c.sources FROM articles a,galleries b,images c WHERE a.id = b.id and b.id = c.id';

  if($result = mysqli_query($conn, $sql)) {
  // your desire calculation

  } else {
        echo "No records matching your query were found.";
  }