# Simple tag-board **URL:** \ **Category:** Uncategorized\ **Created:** [October 14, 2006, 12:41am UTC](https://forum.kirupa.com/t/simple-tag-board/203779 "2006-10-14T00:41:21Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![Mak\_Valley](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@Mak\_Valley](https://forum.kirupa.com/u/Mak_Valley)\ **Post date:** [October 14, 2006, 12:41am UTC](https://forum.kirupa.com/t/simple-tag-board/203779/1 "2006-10-14T00:41:21Z")
don’t know how many of these there are out there… or if there’s already one (or more) on this forum/website… but i made this for a friend and decided to distribute it, so, here’s another one… [http://www.jahdesign.com/tag](http://www.jahdesign.com/tag) \<\< test it, see if you like it… it’s two files… dbconnect.php ```php ``` and index.php ```php Tag Board v0.4 "; echo "Name:
"; echo "OR E-Mail:
"; echo ">\"> "; echo " "; echo "Cancel"; } include ("dbconnect.php"); ?>
",">","$tagmessage2"); if (substr_count($tagemail, "@")){ $tagemail2="mailto:$tagemail"; } else { $tagemail2="$tagemail"; } $inserttags=("INSERT INTO tags VALUES ('','$tagname','$tagemail2','$tagmessage3')"); mysql_query($inserttags) or die ("Error inserting tag!"); echo "Tag posted!"; } } else { / ******************** NO PAGEINATION $selecttags=mysql_query("SELECT * FROM tags ORDER BY id DESC"); while ($tag = mysql_fetch_array($selecttags)){ echo "".$tag['name'].""; echo " : "; echo $tag['message']."

"; } ********************* / // PAGEINATION if(!isset($_GET['page'])){ $page = 1; } else { $page = $_GET['page']; } // MAX RESULTS $max_results = 15; $from = (($page * $max_results) - $max_results); $sql = mysql_query("SELECT * FROM tags ORDER BY id DESC LIMIT $from, $max_results"); / ***********DISPLAY RESULTS**************** / while($row = mysql_fetch_array($sql)){ echo "".$row['name']." : ".$row['message']."
"; } $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM tags"),0); $total_pages = ceil($total_results / $max_results); echo "
Select a Page
"; if($page > 1){ $prev = ($page - 1); echo "< "; } for($i = 1; $i <= $total_pages; $i++){ if(($page) == $i){ echo "$i "; } else { echo "$i "; } } if($page < $total_pages){ $next = ($page + 1); echo "Next>>"; } echo "
"; } //END PAGEINATE ?>
" align="" onmouseover="addtagover();" onmouseout="addtagout();" > "; echo " "; echo ""; echo " "; } ?>
``` if you want to limit the number of results per page, leave everything as is and edit $max\_results to the maximum number of results you want per page… if you DON’T want to pageinate then uncomment where it says “NO PAGEINATION” and delete from where it says “PAGEINATION” to “END PAGEINATION”. remarks anybody?