Re: Parse error: syntax error, unexpected '>' in C:\wamp\www\new.php on line 38

WOW, Both of your suggestions worked like magic. Thanks a lot Patrick -Sashi Patrick Price wrote:

I believe your problem is that on line 33 you forgot your closing double quote in the echo statement. Thanks patrick Sent from: Decatur Ga United States. On Fri, Feb 13, 2009 at 10:02 PM, Sashikanth Gurram <sashi34u@vt.edu> wrote:

Hi all, I have pasted the PHP code I wrote below. I do not know why, but I am getting the parse error: unexpected '>'. It says the error is on line 38. The exact line on line 38 is

*      echo"<tr>\n*

Basically, I am trying to execute an sql query through PHP which tries to extract data from the mysql database and display the data in the browser. The query is running fine but I am getting the problems when I try to display the data in the browser. Can anyone help me with it? Thanks, Sashi <?php /* CONNECTS TO THE DATABASE*/ $host="******"; $user="******"; $password="*******"; $dbname="*********"; $cxn=mysqli_connect($host, $user, $password, $dbname); if (!$cxn=mysqli_connect($host, $user, $password, $dbname)) {

      $error=mysqli_error($cxn);
      echo "$error";
      die();

} else {

      echo "Connection established successfully";

} $sql="select * FROM OCCUPANCY"; $data=mysqli_query($cxn,$sql); if (!$data=mysqli_query($cxn,$sql)) {

      $error=mysqli_error($cxn);
      echo "$error";
      die();

} else {

      echo "Query sent successfully";

} echo "<br>"; echo "<h1>OCCUPANCY<h1>"; echo "<table cellspacing='5'>"; echo "<tr><td colspan='7'><hr /></td></tr>; while ($row=mysqli_fetch_array($data)) {

      extract($row);
      echo"<tr>\n
           <td>$building</td>\n
           <td>$parking_lot</td>\n
           <td>$month</td>\n
           <td>$day</td>\n
           <td>$occupancy</td>\n
           <td>$empty_spaces</td>\n
           <td>$special_days</td>\n
           </tr>\n";
      echo "<tr><td colspan='7'><hr /></td></tr>\n";

}

      echo"</table>\n";

?> -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sashikanth Gurram Graduate Research Assistant Department of Civil and Environmental Engineering Virginia Tech Blacksburg, VA 24060, USA -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sashikanth Gurram Graduate Research Assistant Department of Civil and Environmental Engineering Virginia Tech Blacksburg, VA 24060, USA