Advertisement
Guest User

Untitled

a guest
Jun 24th, 2017
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. <?php
  2.  
  3. $queryget = mysql_query("SELECT * FROM $newstable ORDER BY id DESC LIMIT 2,20");
  4.  
  5. ?><p><strong>Archief</strong></p><p><?php
  6.  
  7. while ($row = mysql_fetch_assoc($queryget)) {
  8. $idPost = $row['id'];
  9. $title = $row['title'];
  10. $shortdatePost = $row['date2'];
  11. $space = urldecode('%20');
  12.  
  13. if (strlen($title) > 13) {
  14. $stitle = substr($title,0,13);
  15. $stitle .= "...";
  16. }
  17.  
  18. echo "$shortdatePost$space<a href=\"index.php?action=view&id=" . $idPost . "&page=1\" title=\"$title\" style=\"color:#333; text-decoration:none\" onmouseover=\"this.style.color='black'\"onmouseout=\"this.style.color='#333'\">$stitle</a><br />";
  19. }
  20.  
  21. $querygetrownum = mysql_num_rows($queryget);
  22. if ($querygetrownum >= 22) {
  23. echo "<a href=\"index.php?action=archief&page=1\" title=\"Archief\" style=\"color:#333; text-decoration:none\" onmouseover=\"this.style.color='black'\"onmouseout=\"this.style.color='#333'\">Kijk dieper in archief...</a>";
  24. }
  25.  
  26. ?></p>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement