parse error

vbasic

I am just starting to learn PHP. I have been following an example off of this tutorial I got but I get a parse error when I access the page. Need help please. The code that I wrote is as follows.

01 <html>
02 <?php
03
04 $db = mysql_connect ("SERVER_NAME", "USER_NAME", "PASSWORD") or die ('I
05 cannot connect to the database because: ' . mysql_error());
06
07 mysql_select_db ("DATABASE_NAME", $db);
08
09 $result = mysql_query("SELECT * FROM TABLE", $db);
10
11 echo "<table>";
12
13echo "<tr><td>NAME<td>AGE<td>ADDRESS</tr>;
14while ($myrow = mysql_fetch_array($result))
15 {
16 echo "<tr><td>";
17 echo $myrow["fname"];
18 echo " ";
19 echo $myrow["lname"];
20 echo "<td>";
21 echo $myrow["age"];
22 echo "<td>";
23 echo $myrow["address"]
24 }
25 echo "</table>";
26 ?>
</html>

And then the page gives me the following error message.\

Parse error: parse error, unexpected '>' on line 15

line 15 is the brace "{" before the first echo inside the while loop.

xblue

2 things: I'd use an editor with syntax highlighting (you can enable syntax highlighting here on the board by using [php] tags) and carefully watch the semicolons that end a statement.

13 missing doublequote
echo "<tr><td>NAME<td>AGE<td>ADDRESS</tr>";
23 missing semicolon
echo $myrow["address"];

vbasic

Thanks for the previous help. I made the changes that were suggested but now I get the following error. Can I I get some susggestions again please?

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/root/pub_html/file.php on line 13

Name Age Address

xblue

... means your query failed for some reason.

use mysql_error() for a more meaningful error message.

$result = mysql_query("SELECT * FROM TABLE", $db)
    or die("Invalid query: " . mysql_error());