SHOW:
|
|
- or go back to the newest paste.
1 | ssgallery_function.php | |
2 | function image_from_database() { | |
3 | $result = mysql_query("SELECT * FROM screenshots ORDER BY date_sub DESC"); | |
4 | - | $count = 0; |
4 | + | $count = mysql_num_rows($result); |
5 | while($count < 4 && $row = mysql_fetch_array($result)) | |
6 | - | { |
6 | + | if ($count > 4) { |
7 | - | $count++; |
7 | + | |
8 | - | echo '<div class="span3">'; |
8 | + | while($row = mysql_fetch_array($result)) { |
9 | - | echo '<img src="'.$row['thumbnail_link'].'" />'; |
9 | + | |
10 | - | echo '</div>'; |
10 | + | echo '<div class="span3">'; |
11 | - | echo ' '; |
11 | + | echo '<img src="'.$row['thumbnail_link'].'" />'; |
12 | - | } |
12 | + | echo '<h4>'.$row['header'].'</h4>'; |
13 | echo '<p>'.$row['description'].'</p>'; | |
14 | echo '<p><a class="btn" href="view_image.php?image_id='. $row['photo_id'] .'">View details »</a></p>'; | |
15 | echo '</div>'; | |
16 | ||
17 | } | |
18 | ||
19 | } | |
20 | } | |
21 | ssgallery.php | |
22 | <div class="container"> | |
23 | <h1 class="text-center">The American Pacific Group ScreenShot Gallery</h1> | |
24 | <hr> | |
25 | <div class="row-fluid"> | |
26 | <?php | |
27 | echo image_from_database(); | |
28 | ?> | |
29 | </div> | |
30 | </div> |