0
I am developing a slideshow based on categories. That is, the categories are pulled from the database and the images are associated with them. However, I am having 2 problems. The first is the miniatures of the categories. One or more thumbnails of categories appear repeated (2 or 3 times), while other categories are not displayed.
The code is:
echo '<h2 class="margin-bototm10" style="text-align:center;">Outras Categorias</h2>';
$result = $mysql->sql_query("select * from TB_CATEGORIA inner join TB_GALERIA on TB_CATEGORIA.PK_CATEGORIA = TB_GALERIA.CATEGORIA where TB_CATEGORIA.DELETED IS NULL AND TB_CATEGORIA.CODUSUARIO=1 AND TIPO='1'");
while ($row = mysql_fetch_assoc($result)) {
echo "<li class='isotope-item col-sm-6 col-md-3' style='list-style-type:none;'>";
echo "<div class='item-box'>";
echo "<figure>";
echo "<a title='".$row['DESCRICAO']."' class='item-hover' href='galerias.php?categoria=".$row['PK_CATEGORIA']."'>";
echo " <span class='overlay color2'></span>";
echo " <span class='inner'>";
echo " <span class='block fa fsize30 fa-picture-o'></span>";
echo "<strong>Ver</strong> Galeria </span>";
echo "</a>";
echo "<img class='img-responsive' src='../images/".$row['IMAGEM']."' width='260' height='260' style='max-height: 170px;' />";
echo "</figure>";
echo "<div class='item-box-desc'>";
echo " <small class='item-box-date'> </small>";
echo "<small style='display: inline;'>".$row['NOME']."</small>";
echo " <div class='row' style='max-width: 250px;'>";
echo " <div class='col-md-12'>";
echo " <p class='similar-h4' style='display: inline;'>".$row['NOME']."</p>";
echo " </div>";
echo "</div>";
echo " </div>";
echo "</div>";
echo "</li>";
The other is the following, in the code is to display only images/categories where the table value DELETED is NULL, I changed this to test, but the original idea is that it is displayed when the table is empty and not null. Because for security reasons, the deleted one only gets the * tag in the DELETED table and only after a few days is it really deleted. I tried with DELETED=', but it didn’t work at all.
What am I doing wrong?
I don’t fully understand the print control part. How exactly should this work? I should put that if after the while or it would be the part?
– Raphael Cordeiro
and what to put in Energy, for example?
– Raphael Cordeiro
I’m confused because on some pages the categories Texts appear repeated like that (taking only the first category and duplicating) but on other pages no category appears.
– Raphael Cordeiro
You put that if in the part where you want to print Thumb. You don’t need Echo, because it prints or doesn’t print Thumbs
– Rodrigo Jarouche
Now the categories are being displayed, but there’s a problem, they’re still repeating themselves. For example, if there are 6 images in the category, it is repeated 6 times, if there are 2 images, it repeats 2 times and so on.
– Raphael Cordeiro
And are only being displayed the categories where the DELETED table is as Null, not empty
– Raphael Cordeiro
placed (TB_CATEGORIA.DELETED IS NULL OR Trim(TB_CATEGORIA.DELETED) <> '')
– Rodrigo Jarouche
Now it worked! Now all that is left is the problem of repeating the category. Instead of just displaying a Thumb, it displays the repeated category with each of the images contained in it. For example, the first with image 1, the second with image 2 and the third with image 3, of the same category. Instead of just taking one of the images and using as Thumb and displaying the category once.
– Raphael Cordeiro
The idea of the solution lies in the answer I gave you...
– Rodrigo Jarouche
I tried here, but it didn’t roll.
– Raphael Cordeiro
Face to logic is a way. Now it’s a matter of understanding, and making the necessary adaptations
– Rodrigo Jarouche