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