1
|
<table width="100%" border="0" cellspacing="3" cellpadding="0"> <tr> <td> </td> </tr> <tr> <td> </td> </tr> <tr> <td> <? $query = mysql_query("SELECT * FROM $table_cat"); $results = mysql_num_rows($query); if($results!=0){echo "<div class='title'>$categories</a></div>";}$query = mysql_query("SELECT * FROM $table_cat ORDER BY id ASC"); while($row = mysql_fetch_array($query)) { $id = $row['id'];$name = $row['name'];echo "<div class='menu'><a href='get.php?catid=$id'>$name</a><br /></div>";}?> </td> </tr> <tr> <td> </td> </tr> <tr> <td> <? echo "<div class='title'>$recent_posts</a>";$query2 = mysql_query ("SELECT * FROM $table ORDER BY id DESC LIMIT 10");while ($myrow = mysql_fetch_array ($query2)) {$title = $myrow['title'];$text = $myrow['text'];$extended = $myrow['extended'];$file = $myrow['image'];$date = $myrow['date'];$username = $myrow['username'];$id = $myrow['id'];echo "<div class='menu'><a href='detail.php?id=$id'>$title</a><br /></div>";}?> </td> </tr> <tr> <td> </td> </tr> <tr> <td> <?echo "<div class='title'>$view_posts_author</a>"; $query3 = mysql_query("SELECT * FROM $table_users ORDER BY login ASC"); while ($row = mysql_fetch_array ($query3)) {$userid = $row['id'];$username = $row['login'];// check if user has published at least one entry - if not, the user will not be displayed in the menu$query4 = mysql_query ("SELECT * FROM $table WHERE userid = $userid");$numrows = mysql_num_rows ($query4);if($numrows){echo "<div class='menu'><a href='get.php?userid=$userid'>$username</a><br /></div>";}}?> </td> </tr> <tr> <td> </td> </tr> <tr> <td> <? echo "<div class='title'>$post_formatting</div>"; echo "<div class='menu'><a href='print.php' target='_blank'>Print</a><br /><a href='xml.php' target='_blank'>XML</a></div>";?> </td> </tr> <tr> <td> </td> </tr> <tr> <td><div class='title'>powered by</div> <div class='zomplog'><a href="http://scripts.zomp.nl" target="_blank">zomplog</a></div></td> </tr> <tr> <td> </td> </tr></table>
|