[MySQL][PHP] Segregowanie po 8 rekordów Opcje

[mrSlowFlow]

Mam takie zapytanie:

[SQL] pobierz, plaintext 
$q = mysql_query("SELECT id,name, FROM photos WHERE gallery='$id'");
[SQL] pobierz, plaintext 

Chcę wyświetlić te zdjęcia na stronie, ale żeby były w grupach po 8. Tak to powinno wyglądać:

[HTML] pobierz, plaintext 
<div>
<ul class="thumbnails">
         <li><a href="images/galleries/1/photo_1.jpg" class="thumb"><img src="images/galleries/1/photo_1_thumb.jpg" /></a></li>
         <li><a href="images/galleries/1/photo_1.jpg" class="thumb"><img src="images/galleries/1/photo_1_thumb.jpg" /></a></li>
         <li><a href="images/galleries/1/photo_1.jpg" class="thumb"><img src="images/galleries/1/photo_1_thumb.jpg" /></a></li>
         <li><a href="images/galleries/1/photo_1.jpg" class="thumb"><img src="images/galleries/1/photo_1_thumb.jpg" /></a></li>
         <li><a href="images/galleries/1/photo_1.jpg" class="thumb"><img src="images/galleries/1/photo_1_thumb.jpg" /></a></li>
         <li><a href="images/galleries/1/photo_1.jpg" class="thumb"><img src="images/galleries/1/photo_1_thumb.jpg" /></a></li>
         <li><a href="images/galleries/1/photo_1.jpg" class="thumb"><img src="images/galleries/1/photo_1_thumb.jpg" /></a></li>
         <li><a href="images/galleries/1/photo_1.jpg" class="thumb"><img src="images/galleries/1/photo_1_thumb.jpg" /></a></li>
         </ul>
      </div>
      <ul class="thumbnails">
         <li><a href="images/galleries/1/photo_1.jpg" class="thumb"><img src="images/galleries/1/photo_1_thumb.jpg" /></a></li>
         <li><a href="images/galleries/1/photo_1.jpg" class="thumb"><img src="images/galleries/1/photo_1_thumb.jpg" /></a></li>
         <li><a href="images/galleries/1/photo_1.jpg" class="thumb"><img src="images/galleries/1/photo_1_thumb.jpg" /></a></li>
         <li><a href="images/galleries/1/photo_1.jpg" class="thumb"><img src="images/galleries/1/photo_1_thumb.jpg" /></a></li>
         <li><a href="images/galleries/1/photo_1.jpg" class="thumb"><img src="images/galleries/1/photo_1_thumb.jpg" /></a></li>
         <li><a href="images/galleries/1/photo_1.jpg" class="thumb"><img src="images/galleries/1/photo_1_thumb.jpg" /></a></li>
         <li><a href="images/galleries/1/photo_1.jpg" class="thumb"><img src="images/galleries/1/photo_1_thumb.jpg" /></a></li>
         <li><a href="images/galleries/1/photo_1.jpg" class="thumb"><img src="images/galleries/1/photo_1_thumb.jpg" /></a></li>
         </ul>
      </div>
[HTML] pobierz, plaintext 

itd.

[iwosz]

http://dev.mysql.com/doc/refman/5.0/en/select.html

google ci nie działa!?

Ten post edytował iwosz 1.09.2010, 17:01:49