Show result in table

skyloon

I have tried to modify this coding, but also cannot show the result,
what is the problem? The error message is "Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in c:\phpweb/account.php on line 26"

Thank you for your help.

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<? $Connect = mysql_connect("localhost","root","");
mysql_select_db("mw");
$result=mysql_query("select * from account");
$number_of_rows = mysql_num_rows($result);

		print "<TABLE CELLSPACING=\"0\" CELLPADDING=\"0\" BORDER=\"1\">\n";
		print "  <TR><TD height=\"45\">Username</TD><TD>Password</TD><TD>Email</TD></TR>\n";


		while ($number_of_rows = mysql_fetch_row($result)){

		echo "<tr>\n";

		echo "<TD>$number_of_rows["username"]"</TD>\n";
		echo "<TD>$number_of_rows["password"]"</TD>\n";
		echo "<TD>$number_of_rows["email"]"</TD>\n";
		echo "<tr>\n";
		}
		mysql_close();
	?>
</td>
    </tr>
  </table>
</td>

</tr>
<tr>
<td> </td>
</tr>
</table>
</body>
</html>

chrima

Change:

echo "<TD>$number_of_rows["username"]"</TD>\n"; 
echo "<TD>$number_of_rows["password"]"</TD>\n"; 
echo "<TD>$number_of_rows["email"]"</TD>\n";

to something like

<TD><? $number_of_rows["username"] ?></TD> 
<TD><? $number_of_rows["password"] ?></TD> 
<TD><? $number_of_rows["email"] ?></TD>

skyloon

although I follow your code, it also can't display the result.

niroshan

hi,
try this code. i think prb. is u used mysql_fetch_row insted of mysql_fetch_array and there is some table problem too.

code

<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<?php
$Connect = mysql_connect("localhost","root","") or die ("Cannot connect to the server");
mysql_select_db("mw") or die ("error selecting db");
$result=mysql_query("select * from account");
// $number_of_rows = mysql_num_rows($result); - no need

			print "<TABLE CELLSPACING=\"0\" CELLPADDING=\"0\" BORDER=\"1\">"; 
			print " <TR><TD height=\"45\">Username</TD><TD>Password</TD><TD>Email</TD></TR>"; 


			while (@$number_of_rows = mysql_fetch_array($result))
			{ 
				echo "<tr>"; 
				echo "<TD>".$number_of_rows[username]."</TD>"; 
				echo "<TD>".$number_of_rows[password]."</TD>"; 
				echo "<TD>".$number_of_rows[email]."</TD>"; 
				echo "</tr>"; 
			} 

			print "</table>";
			mysql_close(); 
			?> 
		</td> 
	</tr> 
	</table> 
</td>

</tr>
</table>
</body>
</html>