Trouble outputting contents of a table to a table

gsfgf

I'm outputting the contents of a one colum MySQL table to an html table.

<HTML>
<HTML>
<?php
include("navbar.inc");
//Navbar, and style sheet are added
//Open database 
$dbUser = "root";
$dbPass = "jeetjeet";
$db = "mini";
$host = "localhost";
$selected = $_GET[select];
$link = mysql_pconnect($host, $dbUser, $dbPass);
if (!link)
	die( "Couldn't Connect to MySQL");
mysql_select_db($db, $link)
	or die ("Couldn't open $db: ".mysql_error());



$fp = fopen("../passwd", 'r');
$rUname = fgets( $fp, 1024  );
$rPass = fgets( $fp, 1024  );



if($selected == "")
{
	print("<center><h2>Categories</h2><Table class=link>\n<caption>Select Category to Edit:</caption>");

$query = "SELECT * FROM categories ORDER BY name";
$result = mysql_query( $query) or die(mysql_error());
$x = 0;
while ($a_row = mysql_fetch_row( $result ))
{
	if( $x % 5 == 0)
		print "\n<TR><TD>";
	else
		print "\n<TD>";
	print("<a href=\"editcat.php?select=$a_row[name]\">$a_row[name]</a>");
	$x++;
}
}
else
print("...");
?>

I just get a blank table. There are records in the table.

tomhath

Only two things that jump out are:

1) You never have any </td>, </tr>, or </table> tags.

2) Proper way to reference the array entry is with the key quoted: $a_row["name"]

gsfgf

1) That wouldn't be causing this problem.

2) since i'm inside a print() parameter ["name"] won't work, ['name'] and [\"name\"] give parse errors.

with <a href=\"editcat.php?select=$a_row[\"name\"]\">

Parse error:  parse error, unexpected T_CHARACTER, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /usr/local/www/ data.default/house/admin/editcat.php on line 39

with <a href=\"editcat.php?select=$a_row['name']\">

Parse error:  parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /usr/ local/www/data.default/house/admin/editcat.php on line 39