Parse Error Line 91...

Anon

Question, I am getting parse error on line 91. This is the first PHP script I have ever attempted to right (so no wonder). It is pasted below. See anything that is a no go that I figured would be possible?

<?php

#connect to db
$dbcnx = @mysql_connect("localhost", "username", "password");
if (!$dbcnx) {
echo( "Unable to connect to the database server at this time.");
exit();
}

#change subject to wildcard if one of not specified
if ($subject=="") {
$subject = '%';
}

#change search to wildcard if nothing is specified
if ($search=="") {
$search = '%';
}

#select database
if (!@mysql_select_db("Correspondence")) {
echo( "Unable to locate data");
exit();
}

#queries database
$result = mysql_query("SELECT Date, Subject, Author, Title, Document_Number, HREF FROM Correspondence WHERE PID=$plant AND UID=$unit AND CID=$cycle AND Subject=$subject AND Title=$search ORDER by $date");

if (!$result) {
echo ("Error querying data" . mysql_error() . "");
exit();
}

#snags results
while ( $row = mysql_fetch_array($result) ) {

  <tr align=left>
     <td align="center"><?php echo($row["Date"]); ?></td>
     <td align="center"><?php echo($row["Subject"]); ?></td>
     <td align="center"><?php echo($row["Author"]); ?></td>
     <td align="center"><?php echo($row["Title"]); ?></td>
     <td align="center"><?php echo($row["Document_Number"]); ?></td>
     <td align="center"><a href="<?php echo($row["HREF"]); ?>">Go</a></td>
  </tr>

While I am at it, anyone know much about SSI and a datestamp? I have a javascript at the bottom of my pages that checks their modification date, but with SSI the page is created each time it is displayed. Is there a way I could write something in PHP (that would execute before the SSI) so the date is accurate?

Thanks for the help.

Anon

Which line is 91?

Anon

Sorry about that, forgot to mention it. The thing is, line 91 appears after I've closed out of php and am doing html. Line 91 is a

     <td align="center"><a href="<?php echo($row["HREF"]); ?>">Go</a></td>
  </tr>

#<?php

#selects different database and repeats
#elseif ($identifier=="letterbooks") {

<-91

Anon

Strike that, 91 is the last line of the script I originally submitted...

That is line 91.
(I forgot I made some changes up top)

Anon

I feel like an idiot. Disregard all my posts beyond the one at 16:40:28.

skidge

If that is your entire script posted in the first post you made, I think your problem is that you never closed the final while loop brackets. If that's so, you should try adding:

<?
}
?>

After the table rows to close the while loop.

Hope that helps.

Anon

Forgot about that. I went ahead and closed it (wasn't even sure if you could leave it open and ?> out of php like that).

The four lines I added (three you suggested plus a line of whitespace now have the parse error on 95. The line with the

Anon

Well I don't know, but if that is your code, you should replace the

#<?php

#}

part with

<?php
}

?>

You noticed that PHP never ever screams if the HTML Code is wrong ... therefore line 91 needs to be PHP Code (which you obviously did not intend, because ist not a PHP "tag"), well hope that helps ...

cya Rob