Sorry to paste such a huge bit of coide but i get this error:

Parse error: parse error in /home/nanothre/public_html/guestbook/index.php on line 170

when i try and view the page

here is my code

PHP Code:

<?

//set variables
$db_host = "localhost";
$db_username = "nanothre_liam";
$db_password = "******";
$db_name = "nanothre_guestbook";

//connect to database
if ($submit) {
mysql_connect($db_host,$db_username,$db_password) or die(mysql_error());
mysql_select_db($db_name) or die(mysql_error());

//run query to retrieve data from database for posts
$query = "SELECT name, email, message, date, FROM guestbook order by id DESC LIMIT 10";
$result = mysql_query($query);

//set table properties
echo "<br><table align='center' width='85%' border='1' bordercolor='#333333'>";

//loop to add entries of database
while($r=mysql_fetch_array($result))
{

echo "<tr>";
echo "<td bordercolor='#CCCCCC'>$r[message]</td>";
echo "</tr>";
echo "<tr>";
echo "<td bordercolor='#CCCCCC'>Posted By:
<a href='mailto:$r[email]'>$r[name]</a> $r[date]</td>";
echo "</tr>";
}
echo "</table>";
?>

</p>
</td>
</tr>
</table>
</div>
</body>
</html>                  <<<<<<<<<<<Line 170

Thanks!

Ok try removing the HTML.... becuase its php anyway....
HTML is not a needed declaration.

You missed a } for the if.

PHP Code:

<?

//set variables
$db_host = "localhost";
$db_username = "nanothre_liam";
$db_password = "******";
$db_name = "nanothre_guestbook";

//connect to database
if($submit)
{
    mysql_connect($db_host,$db_username,$db_password) or die(mysql_error());
    mysql_select_db($db_name) or die(mysql_error());

    //run query to retrieve data from database for posts
    $query = "SELECT name, email, message, date, FROM guestbook order by id DESC LIMIT 10";
    $result = mysql_query($query);

    //set table properties
    echo "<br><table align='center' width='85%' border='1' bordercolor='#333333'>";

    //loop to add entries of database
    while($r=mysql_fetch_array($result))
    {
        echo "<tr>";
        echo "<td bordercolor='#CCCCCC'>$r[message]</td>";
        echo "</tr>";
        echo "<tr>";
        echo "<td bordercolor='#CCCCCC'>Posted By:
        <a href='mailto:$r[email]'>$r[name]</a> $r[date]</td>";
        echo "</tr>";
    }
    echo "</table>";
}   // <<<<<<<<
?>

</p>
</td>
</tr>
</table>
</div>
</body>
</html>

thank you, simple mistake messed it all up

Did that fix it?

I have always had problems when doing something like:

PHP Code:

echo "some text $array['value'] and some more text"; 


Shouldn't it be:

PHP Code:

echo "some text ".$array['value']." and some more text"; 


...?

No, shold work like that. Problems come when you're trying to access a multi-dimension array, I think. Ex:

PHP Code:

echo "blah $array['key']['key'] blah";
// should be
echo "blah {$array['key']['key']} blah";
// or
echo "blah " . $array['key']['key'] . " blah";