Fetching a row but putting all of them in tables.

[runar56]

Hi,

Sorry if I've posted in the wrong forum.
I am trying to fetch rows from the database, but I also want all the rows to be displayed in tables. All of them. This is the code I've used so far:

<?php
error_reporting(E_ALL); 
include "common_db.php";
db_connect('****'); 
mysql_select_db('****');
$user_query = mysql_query("SELECT page_id, page_name, page_url, display_menu FROM content");

while ($row = mysql_fetch_array($user_query)) {
	$pageid = $row["page_id"];
	$pagename = $row["page_name"];
	$pageurl = $row["page_url"];
	$pagemenu = $row["display_menu"];
  echo "<TR>\n";
  echo "<TD WIDTH=\"25%\" ALIGN=\"CENTER\">$pageid</TD>\n";
  echo "<TD WIDTH=\"25%\" ALIGN=\"CENTER\">$pagename</TD>\n";
  echo "<TD WIDTH=\"25%\" ALIGN=\"CENTER\">$pageurl</TD>\n";
  echo "<TD WIDTH=\"25%\" ALIGN=\"CENTER\">$pagemenu</TD>\n";
  echo "<TD WIDTH=\"25%\" ALIGN=\"CENTER\">edit?</TD>\n";
  echo "</TR>\n";
  echo "</table>\n";
}
?>

I've got 2 inserted rows, but this code only shows 1 in the tables. And shows the other one not in tables. Anyone know how to do this?

Thanks!😉

[biggus]

try closing the table tag after the while loop instead of inside it.

[devinemke]

<?
error_reporting(E_ALL);

include('common_db.php');
db_connect('****');
mysql_select_db('****');

$result = mysql_query('SELECT page_id, page_name, page_url, display_menu FROM content');
echo '<table>';
while ($row = mysql_fetch_assoc($result))
{ 
	echo '
	<tr align="center">
	<td>' . $row['page_id'] . '</td>
	<td>' . $row['page_name'] . '</td>
	<td>' . $row['page_url'] . '</td>
	<td>' . $row['display_menu'] . '</td>
	<td>edit?</td>
	</tr>
	'; 
}
echo '</table>';
?>

[runar56]

Once again thanks for your help!🙂