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

[Sashikanth Gurram]

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 <sashi...@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


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php