Hello i can not figure out how to take images from my database to jQuery gallery.
User uploaded images in the data base. Images are sorted by date.
And how I can do, what all imges goe's in the jQuery gallery, besause now i can get all imges in one column with code.
Tnxs for help me! :)
<?php
$query_picture = "SELECT * FROM `Failai`";
$result_picture = mysql_query($query_picture);
$count=mysql_num_rows($result_picture);
if (mysql_num_rows($result_picture) > 0) {
mysql_data_seek($result_picture, $fotonumeris);
} else { print("Failu nerasta"); }
while($row_picture = mysql_fetch_array($result_picture)){
$z = $z + 1;
$rowpct = $row_picture['Vieta'];
print("<span class=center><img width=562px height=500px src=$rowpct alt=example/></span></br>");
}
?>
And my jQuery gallery gets images now from:
<div class="advanced-slider" id="responsive-slider">
<ul class="slides">
<li class="slide">
<img class="image" src="images/1.jpg" alt=""/>
<img class="thumbnail" src="images/1.jpg" alt=""/
</li>
<li class="slide">
<img class="image" src="images/2.jpg" alt=""/>
<img class="thumbnail" src="images/3.jpg" alt=""/
</li>
<li class="slide">
<img class="image" src="images/3.jpg" alt=""/>
<img class="thumbnail" src="images/3.jpg" alt=""/>
</li>
<li class="slide">
<img class="image" src="images/4.jpg" alt=""/>
<img class="thumbnail" src="images/4.jpg" alt=""/>
</li>
<li class="slide">
<img class="image" src="images/5.jpg" alt=""/>
<img class="thumbnail" src="images/5.jpg" alt=""/>
</li>
<li class="slide">
<img class="image" src="images/6.jpg" alt=""/>
<img class="thumbnail" src="images/6.jpg" alt=""/>
</li>
</ul>
</div>