Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host="localhost"; // Host name
- $username="root"; // Mysql username
- $password=""; // Mysql password
- $db_name="website_features"; // Database name
- $tbl_name="thread"; // Table name
- // Connect to server and select databse.
- mysql_connect("$host", "$username", "$password")or die("cannot connect");
- mysql_select_db("$db_name")or die("cannot select DB");
- $sql="SELECT * FROM $tbl_name ORDER BY id DESC";
- // OREDER BY id DESC is order result by descending
- $result=mysql_query($sql);
- ?>
- <html>
- <table width="90%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
- <tr>
- <td width="6%" align="center" bgcolor="#E6E6E6"><strong>#</strong></td>
- <td width="53%" align="center" bgcolor="#E6E6E6"><strong>Topic</strong></td>
- <td width="15%" align="center" bgcolor="#E6E6E6"><strong>Views</strong></td>
- <td width="13%" align="center" bgcolor="#E6E6E6"><strong>Replies</strong></td>
- <td width="13%" align="center" bgcolor="#E6E6E6"><strong>Date/Time</strong></td>
- </tr>
- </html>
- <?php
- while($rows=mysql_fetch_array($result)){ // Start looping table row
- ?>
- <html>
- <tr>
- <td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
- <td bgcolor="#FFFFFF"><a href="view_topic.php?id=<? echo $rows['id']; ?>"><? echo $rows['topic']; ?></a><BR></td>
- <td align="center" bgcolor="#FFFFFF"><? echo $rows['view']; ?></td>
- <td align="center" bgcolor="#FFFFFF"><? echo $rows['reply']; ?></td>
- <td align="center" bgcolor="#FFFFFF"><? echo $rows['datetime']; ?></td>
- </tr>
- </html>
- <?php
- // Exit looping and close connection
- }
- mysql_close();
- ?>
- <html>
- <tr>
- <td colspan="5" align="right" bgcolor="#E6E6E6"><a href="createtopic.php"><strong>Create New Topic</strong> </a></td>
- </tr>
- </table>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement