Parse error: parse error, unexpected '>'

[jjfletch]

Hmm, I keep getting the Parse error: parse error, unexpected '>' message. Can anyone tell me what is causing this to happen? Help is appreciated.

[FONT=courier new]
<?php

require_once ('../files/mysql_connect.php');

if (isset($_GET['submit'])) {

if (!empty($GET['lastname'])) {
$ln = escape_data($GET['lastname']);
} else {
$ln = FALSE;
echo '<p><font color="red">Please enter a Last Name</font></p>';
}

if (!empty($GET['firstname'])) {
$fn = escape_data($GET['firstname']);
} else {
$fn = '%';
}

if ($ln && $fn) {

 $query = "SELECT * from tablename where LastName like ('$ln') AND FirstName like ('$fn');

}

 $result = mysql_query ($query);
 while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {

 echo "
     <tr>
     <td><a href=\"viewrecord.php?did={$row['doc_id']}\">{$row['doc_id']}</a></td>
     <td><div align=\"left\">{$row['LastName']}</div></td>
     <td><div align=\"left\">{$row['FirstName']}</div></td>
     <td><div align=\"left\">{$row['County']}</div></td>
     <td><div align=\"left\">{$row['Phone1']}</div></td>
     </tr>
     \n";

}
}
echo '</table>';

mysql_close();
?>[/COLOR][/FONT]

Thanks!

[kingbear]

The first syntax error I see is that you're missing the ending quote on the SQL statement.

It should read:

 $query = "SELECT * from tablename where LastName like ('$ln') AND FirstName like ('$fn')";

[jjfletch]

I must have spent the past 3 hours looking at each line to see if I missed something.

Thanks!