mangolinux Posted September 11, 2015 Share Posted September 11, 2015 I am trying to get my query results to display each result separtlly on its own line. Here is my code: <?phpinclude("dbinfo.inc.php");$query = "SELECT * FROM boc";$result = mysqli_query($con, $query);/* fetch associative array */while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){ //Assign variables $post_id = $row['post_id']; $date = $row['date']; $type = $row['type']; $title = $row['title']; $content = $row['content']; }?> <?phpecho "$date - <a href=\"viewnotice.php?id={$post_id}\"'>{$title}</a>";/* free result set */ mysqli_free_result($result);mysqli_close($con);?> This currently displays the results like this 09-04-2015 - Rescheduling Board of Commissioners Meeting 09-04-2015 - September Committee Meetings I would like it to display like this 09-04-2015 - Rescheduling Board of Commissioners Meeting 09-04-2015 - September Committee Meetings Thanks Quote Link to comment Share on other sites More sharing options...
QuickOldCar Posted September 11, 2015 Share Posted September 11, 2015 Do within the while loop. <?php include("dbinfo.inc.php"); $query = "SELECT * FROM boc"; $result = mysqli_query($con, $query); /* fetch associative array */ while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { //Assign variables $post_id = $row['post_id']; $date = $row['date']; $type = $row['type']; $title = $row['title']; $content = $row['content']; echo "$date - <a href='viewnotice.php?id=".$post_id."'>".$title."</a><br />"; } /* free result set */ mysqli_free_result($result); mysqli_close($con); ?> Quote Link to comment Share on other sites More sharing options...
mangolinux Posted September 11, 2015 Author Share Posted September 11, 2015 Thanks for the quick reply, 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.