Parse error: syntax error, unexpected '>' in C:\... on line

alack06

I am new to php. I am recieving this error:

Parse error: syntax error, unexpected '>' in C:... on line 49

Can anyone help me figure out what the issue is here?

id_ivan

obviously, check line 49 on your code..

alack06

Well of course I did that but like I said I am new to using php so I have no idea what I did wrong. My code is as follows:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTDxhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>
    <title>Campbell Sales</title>
    <meta http-equiv="content-type" content="text/html;charset=utf-8" />
</head>

<body>

<?php

// Connect and select a database
mysql_connect("localhost", "root", "");
mysql_select_db("addressBook");

//Run a query
$result = mysql_query("SELECT * FROM inventory WHERE PartNumber = 'R10 ZZ');

?>


<h1>Campbell Sales</h1>

<table border='1' cellpadding='2' cellspacing='3'
	    summary=\"Table holds Cambell inventory information\">
	<tr>
	     <th>isle</th>
	     <th>col</th>
	     <th>r</th>
	     <th>row</th>
	     <th>quantity</th>
	     <th>partnumber</th>
	     <th>surplus</th>
	     <th>description</th>
	     <th>cost</th>
	     <th>entryorder</th>
	     <th>icrr</th>
	     <th>irrc</th>
	     <th>rowm</th>
	</tr>

   <?php

// Loop through all table rows
while ($row = mysql_fetch_array($result)) {
	echo "<tr>";
	echo "<td>" . $row['isle'] . "</td>";
	echo "<td>" . $row['col'] . "</td>";
	echo "<td>" . $row['r'] . "</td>";
	echo "<td>" . $row['row'] . "</td>";
	echo "<td>" . $row['quantity'] . "</td>";
	echo "<td>" . $row['partnumber'] . "</td>";
	echo "<td>" . $row['surplus'] . "</td>";
	echo "<td>" . $row['description'] . "</td>";
	echo "<td>" . $row['cost'] . "</td>";
	echo "<td>" . $row['entryorder'] . "</td>";
	echo "<td>" . $row['icrr'] . "</td>";
	echo "<td>" . $row['irrc'] . "</td>";
	echo "<td>" . $row['rowm'] . "</td>";
	echo "</tr>";
    }

    // Free result memory and close database connection
    mysql_free_result($result);
    mysql_close();

 ?>
 </table>
  </body>

  </html>

With line 49 being:

echo "<tr>";

id_ivan

you're missing a quote near the end of line 20

    $result = mysql_query("SELECT * FROM inventory WHERE PartNumber = 'R10 ZZ'");

bradgrafelman

I modified your post to use the [noparse]

 bbcode tags rather than the generic [code] bbcode tags[/noparse] so that syntax highlighting (something your editor should be doing anyway!) is performed.

Having done that, you should notice that the color-coding goes awry after the line where you define [b]$result[/b]. Further inspection of that line reveals a missing string delimiter (a double quote, to be exact).

EDIT: Also, as dagon pointed out in your duplicate thread (which has been merged/deleted), please do [b]not[/b] cross-post the same topic across multiple forums.