Re: [PHP-DB] 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 <[email protected]> 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