HELP(Writing MySQL databse data to web page)

[theinfomaster]

Hi,
I have a problem, when I run this script the browser has a problem with the "{" at the bottom of this page. I have changed its color to red. What am I doing wrong?


<?php
$con = mysql_connect("localhost", "******", "******");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("theinfo_forum1", $con);
$result = mysql_query("SELECT * FROM person");
echo "<table border='1'>
<tr>
<th>Member#</th>
<th>UserName</th>
</tr>";while($row = mysql_fetch_array($result)
{
echo "<tr>";
echo "<td>" . $row['member_#'] . "</td>";
echo "<td>" . $row['member_name'] . "</td>";
echo "</tr>";
}
echo "</table>";mysql_close($con);
?>

[vladimir_cz]

take look on string
while($row = mysql_fetch_array($result)
and count "(" and ")"

[theinfomaster]

With that row of code changed I get the error,
Parse error: syntax error, unexpected '>' in /home/theinfo/public_html/tests/members.php on line 89

Line 89 looks like,
echo "<tr>";

This is what I changed the code to that you told me to,
while($row = mysql_fetch_array($result) and count "and"


There is still something wrong.

[vladimir_cz]

ok. so, please, I just ask you count "(" and ")" in line. don't write just count...

ps:
while($row = mysql_fetch_array($result))

[theinfomaster]

Sorry about that(Im not to bright for my knowledge).
Ok now a new problem has occured. When I testes it the error msg,
Parse error: syntax error, unexpected '>' in /home/theinfo/public_html/tests/members.php on line 89

Now I dont understand what its problem is now.(I wrote the line # in red)

87.while($row = mysql_fetch_array($result))
88. {
89.echo "<tr>";
90.echo "<td>" . $row['member_#'] . "</td>";
91.echo "<td>" . $row['member_name'] . "</td>";
92.echo "</tr>";
93.}

Im sorry for all the questions.

[vladimir_cz]

take look lines above "while"
you don't close double quote somewhere.

[theinfomaster]

Shoot, I cant find a double quote that I dident close off.

[JustPHP]

Can't see any double quotes missing either. You have posted only part of the code, whats above it. Have you looked in there.

[vladimir_cz]

solution: comment strings 87-93. this can help you for locate error.

[theinfomaster]

Lets see, That bit of code on the first post of this thread is the only part of the web page that has any PHP or MySQL code in it. I checked to see if I did something wrong in the HTML by copying and pasting it into an HTML document. Wonce I did that my software I use would have presented me with the error. Due to finding non I put comments around the strings 87-93 and tested this. All it did was change the line of code that had the error.
Here is the updated code to what I was told to do,
<?php
$con = mysql_connect("localhost", "******", "******");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("theinfo_forum1", $con);

$result = mysql_query("SELECT * FROM member_info");

echo "<table border='1'>
<tr>
<th>Member Email</th>
<th>UserName</th>
</tr>
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['UserName'] . "</td>";
echo "<td>" . $row['Email'] . "</td>";
echo "</tr>";
}
echo "</table>";

mysql_close($con);
?>


I still dont see any thing wrong with it. I guess I dont really understand. It has a problem with the "<>" on the tags were the Echo "<>" are.