thought the code would be useful
$query = "
SELECT *
FROM <code>wp_term_taxonomy</code>
INNER JOIN wp_terms ON wp_term_taxonomy.term_id = wp_terms.term_id
WHERE taxonomy = 'post_tag'
";
$result = mysql_query($query);
//$row = mysql_fetch_array($result);
while( $row = mysql_fetch_array($result)) {
//echo $row['term_taxonomy_id'];
/* echo $row['name']."<br />";
echo $row['slug']."<br />"; */
echo "<a href='http://localhost/blog/?tag=$row[name]' >$row[name]</a>"."<br />";
}
ok so i found a couple ways you can do this and they are:
http://codex.wordpress.org/Function_Reference/get_pages
do it through code
or simpler way
http://www.vtardia.com/improved-include-page/
one line of code using a plugin