wee493 Posted June 1, 2009 Share Posted June 1, 2009 I have an array that I'm trying to display from an sql db. The array is displaying fine, but it messes with the html code. <? $user = $session->username; $sql = "SELECT * FROM `url` WHERE `user`='$user' ORDER BY `url`.`id` ASC"; $result = mysql_query($sql); if(mysql_num_rows($result) == '0') { echo "<font color='#000'>You have not created any URL's yet. You can do so from the home screen.</font>"; } while($row = mysql_fetch_array($result) or die(mysql_error())) { $url = stripslashes($row[url]); $dest = stripslashes($row[destination]); echo "<tr bgcolor='#fff'> <td width='200' valign='bottom'> <a href=\"http:\//wiurl.com/$url\">http://wiurl.com/$url</a></td> <td width='200' align='left' valign='bottom'><br>$dest</tr>"; } ?> If i put the closing } from the while command at the very end of the page some of the html is repeated, but if i put it where it is displayed currently the page does not display the html after the php code. you can see the messed up page here http://wiurl.net/myurls.php If you want to see the entire page i have attached it below, <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>WiURL - Make any URL a Wi one</title> <link rel="stylesheet" type="text/css" href="style.css" media="screen" /> </head> <body> <table border="0" align="center"> <tr> <td height="10" bordercolor="#CCCCCC"> </td> </tr> <tr> <td> <div id="wrapper"> <div id="header"> <div id="logo"> <h1><a href="#">WiURL</a></h1> <p>Make any URL a Wi one</p> </div> <!-- end #logo --> <div id="menu"> <ul> <li class="active"><a href="http://wiurl.com">Home</a></li> <li class="active2"><a href="total.php">Top URL's</a></li> <li class="active2"><a href="download.htm">Download</a></li> <li class="active2"><a href="templates/construction.htm">Support</a></li> </ul> </div> <!-- end #menu --> </div> <!-- end #header --> <div id="page"> <div id="content"> <div class="post"> <h1 class="title">Create a WiURL</h1> <table border="0" bgcolor="#FFFFFF" width="400"> <? $user = $session->username; $sql = "SELECT * FROM `url` WHERE `user`='$user' ORDER BY `url`.`id` ASC"; $result = mysql_query($sql); if(mysql_num_rows($result) == '0') { echo "<font color='#000'>You have not created any URL's yet. You can do so from the home screen.</font>"; } while($row = mysql_fetch_array($result) or die(mysql_error())) { $url = stripslashes($row[url]); $dest = stripslashes($row[destination]); echo "<tr bgcolor='#fff'> <td width='200' valign='bottom'> <a href=\"http:\//wiurl.com/$url\">http://wiurl.com/$url</a></td> <td width='200' align='left' valign='bottom'><br>$dest</tr>"; } ?> </table> </div> <br /><br /></div> <!-- end #content --> <div id="sidebar"> <div id="sidebar-bgtop"></div> <div id="sidebar-content"> <div id="sidebar-bgbtm"> <ul> <? include("sidebar.php"); ?> </ul> </div> </div> </div> <!-- end #sidebar --> </div> <!-- end #page --> </div> <div id="footer"> <p>© 2009. Base Design by <a href="http://www.freecsstemplates.org/">Free CSS Templates</a>. Other Modifications by <u>Wee493</u></p> </div> </td></tr></table> <!-- end #footer --> </body> </html> Quote Link to comment Share on other sites More sharing options...
wee493 Posted June 1, 2009 Author Share Posted June 1, 2009 Basically my code is stoping after the while command *Sorry I could not find the edit post button* Quote Link to comment Share on other sites More sharing options...
Ken2k7 Posted June 1, 2009 Share Posted June 1, 2009 Change you while to: while($row = mysql_fetch_array($result)) { $url = stripslashes($row[url]); $dest = stripslashes($row[destination]); echo "<tr bgcolor='#fff'> <td width='200' valign='bottom'> <a href=\"http:\//wiurl.com/$url\">http://wiurl.com/$url</a></td> <td width='200' align='left' valign='bottom'><br>$dest</tr>"; } Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.