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@xxxxxx> 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
>
>
