god_zun Posted September 10, 2008 Share Posted September 10, 2008 I am trying to create a forum and everything works fine except when I go to view the topics in the browser they don't show up....just a blank table. However, they do show up on the database... here is the entire code. If anyone can help please let me know ASAP. <?php $host="localhost"; // Host name $username="intranet"; // Mysql username $password="int$123"; // Mysql password $db_name="intranet"; // Database name $tbl_name="forum_question"; // Table name // Connect to server and select databse. $conn=mysql_connect("$host", "$username", "$password")or die("cannot connect"); $db=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); ?> <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> <?php while($rows=mysql_fetch_array($result)){ // Start looping table row ?> <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> <?php // Exit looping and close connection } mysql_close(); ?> <tr> <td colspan="5" align="right" bgcolor="#E6E6E6"><a href="create_topic.php"><strong>Create New Topic</strong> </a></td> </tr> </table> Link to comment https://forums.phpfreaks.com/topic/123686-solved-why-arent-my-rows-echoing/ Share on other sites More sharing options...
DarkWater Posted September 10, 2008 Share Posted September 10, 2008 It could be because you're using short tags. Don't use them. Link to comment https://forums.phpfreaks.com/topic/123686-solved-why-arent-my-rows-echoing/#findComment-638686 Share on other sites More sharing options...
god_zun Posted September 10, 2008 Author Share Posted September 10, 2008 Quick fix...thanks buddy Link to comment https://forums.phpfreaks.com/topic/123686-solved-why-arent-my-rows-echoing/#findComment-638687 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.