Show result in table

skyloon · #1 02-Jul-2003, 22:13

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' or `T_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>

JdS · #2 03-Jul-2003, 18:30

This bit here:

PHP Code:


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

You could do either instead:

PHP Code:


<?php

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

// Another way... note the curly braces aka 'complex syntax'
echo "<TD>{$number_of_rows['username']}</TD>\n";
echo "<TD>{$number_of_rows['password']}</TD>\n";
echo "<TD>{$number_of_rows['email']}</TD>\n";

// Or what I personally prefer
echo '<TD>'.$number_of_rows['username']."</TD>\n";
echo '<TD>'.$number_of_rows['password']."</TD>\n";
echo '<TD>'.$number_of_rows['email']."</TD>\n";
?>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PHP script to show last referrer url and top referrer to your site	jrobbio	MySQL / PHP Forum	6	22-May-2006 01:06
Recall table row	misunderstood	MySQL / PHP Forum	3	23-Aug-2003 08:56
top of table	Charlie	Web Design Forum	7	27-Mar-2003 02:21
[Tutorial] MySQL Basics	nniehoff	MySQL / PHP Forum	15	23-Mar-2003 19:42
table question	smoky	Web Design Forum	1	05-Jan-2003 02:45

Show result in table

PHP Variable parsing