Troubleshooting "unexpected $end" error
<p>I am new to PHP and trying to get the following code to work:</p>

<pre><code>&lt;?php
include 'config.php';
include 'opendb.php';

$query = "SELECT name, subject, message FROM contact";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
    echo "Name :{$row['name']} &lt;br&gt;" .
         "Subject : {$row['subject']} &lt;br&gt;" . 
         "Message : {$row['message']} &lt;br&gt;&lt;br&gt;";
"ARTICLE_NO :{$row['ARTICLE_NO']} &lt;br&gt;" .
"ARTICLE_NAME :{$row['ARTICLE_NAME']} &lt;br&gt;" .
"SUBTITLE :{$row['SUBTITLE']} &lt;br&gt;" .
"CURRENT_BID :{$row['CURRENT_BID']} &lt;br&gt;" .
"START_PRICE :{$row['START_PRICE']} &lt;br&gt;" .
"BID_COUNT :{$row['BID_COUNT']} &lt;br&gt;" .
"QUANT_TOTAL :{$row['QUANT_TOTAL']} &lt;br&gt;" .
"QUANT_SOLD :{$row['QUANT_SOLD']} &lt;br&gt;" .
"STARTS :{$row['STARTS']} &lt;br&gt;" .
"ENDS :{$row['ENDS']} &lt;br&gt;" .
"ORIGIN_END :{$row['ORIGIN_END']} &lt;br&gt;" .
"SELLER_ID :{$row['SELLER_ID']} &lt;br&gt;" .
"BEST_BIDDER_ID :{$row['BEST_BIDDER_ID']} &lt;br&gt;" .
"FINISHED :{$row['FINISHED']} &lt;br&gt;" .
"WATCH :{$row['WATCH']} &lt;br&gt;" .
"BUYITNOW_PRICE :{$row['BUYITNOW_PRICE']} &lt;br&gt;" .
"PIC_URL :{$row['PIC_URL']} &lt;br&gt;" .
"PRIVATE_AUCTION :{$row['PRIVATE_AUCTION']} &lt;br&gt;" .
"AUCTION_TYPE :{$row['AUCTION_TYPE']} &lt;br&gt;" .
"INSERT_DATE :{$row['INSERT_DATE']} &lt;br&gt;" .
"UPDATE_DATE :{$row['UPDATE_DATE']} &lt;br&gt;" .
"CAT_1_ID :{$row['CAT_1_ID']} &lt;br&gt;" .
"CAT_2_ID :{$row['CAT_2_ID']} &lt;br&gt;" .
"ARTICLE_DESC :{$row['ARTICLE_DESC']} &lt;br&gt;" .
"DESC_TEXTONLY :{$row['DESC_TEXTONLY']} &lt;br&gt;" .
"COUNTRYCODE :{$row['COUNTRYCODE']} &lt;br&gt;" .
"LOCATION :{$row['LOCATION']} &lt;br&gt;" .
"CONDITIONS :{$row['CONDITIONS']} &lt;br&gt;" .
"REVISED :{$row['REVISED']} &lt;br&gt;" .
"PAYPAL_ACCEPT :{$row['PAYPAL_ACCEPT']} &lt;br&gt;" .
"PRE_TERMINATED :{$row['PRE_TERMINATED']} &lt;br&gt;" .
"SHIPPING_TO :{$row['SHIPPING_TO']} &lt;br&gt;" .
"FEE_INSERTION :{$row['FEE_INSERTION']} &lt;br&gt;" .
"FEE_FINAL :{$row['FEE_FINAL']} &lt;br&gt;" .
"FEE_LISTING :{$row['FEE_LISTING']} &lt;br&gt;" .
"PIC_XXL :{$row['PIC_XXL']} &lt;br&gt;" .
"PIC_DIASHOW :{$row['PIC_DIASHOW']} &lt;br&gt;" .
"PIC_COUNT :{$row['PIC_COUNT']} &lt;br&gt;" .
"ITEM_SITE_ID :{$row['ITEM_SITE_ID']};
 }

include 'closedb.php';

?&gt;
</code></pre>

<p>However I get this error:</p>

<pre><code>Parse error: syntax error, unexpected $end in C:\Programme\EasyPHP 2.0b1\www\test.php on line 56
</code></pre>

<p>I would also like to know if there is perhaps an easier way to obtain mysql records instead of typing by hand?</p>

<p>edit:</p>

<p>I fixed the semicolon and quote issue, and now get:</p>

<pre><code>Parse error: syntax error, unexpected T_STRING in C:\Programme\EasyPHP 2.0b1\www\test.php on line 51
</code></pre>

<p>I am sorry I don't know how to make colors in the code.</p>
