[RESOLVED] MySQL blog

[ninjanutz]

on this script i keep getting this error Parse error: syntax error, unexpected $end in C:\Program Files\xampp\htdocs\xampp\Sites\Band\Templates\forum.php on line 55 (line 55 is the last line </form> line )

<?php

if (isset ($_POST['submit']))
{
	if ($dbc = @mysql_connect ('localhost', 'root', ''))
	{
		if (!@mysql_select_db ('forum'))
		{
			die ('<p>Could not select the database because: <b>' . mysql_error() . '</b></p>');
		}
	$query = "INNSERT INTO forum_entries (blog_id, title, entry, date_entered)
		 VALUES (0, '{$_POST['title']}', '{$_POST['entry']}', NOW())";
	if (@mysql_query ($query))
	{
		echo '<p>The blog entry has been added.</p>';
	} else {
		echo "<p>Could not add the entry because: <b>" . mysql_error() . "</b>. The query was $query</p>";
	}	
} 
	mysql_close();

if ($dbc = @mysql_connect ('localhost', 'root', ''))
{
	if (!@mysql_select_db ('forum'))
	{
		die ('<p>Could not select the database because: <b>' . mysql_error() . '</b></p>');
	}

$query = 'SELECT * FROM forum_entries ORDER BY date_entered ASC';
if ($r = mysql_query ($query))
{
	while ($row = mysql_fetch_array ($r))
	{
		echo "<p><h3>{$row['title']}</h3>{$row['entry']}<br />
		     <a href=\"forum.php?id={row['forum_id']}\">Edit</a>
		     <a href=\"delete_entry.php?id={$row['blog_id']}\">Delete</a>
		     </p><hr />\n";
	}
} else {
	die ('<p>Could not retrieve the data because: <b>' . mysql_error() ."'</b>The query was $query</p>");
}


mysql_close();


							

?>

	<form acrtion="forum.php" method="post">
	     <p>Entry Title: <input type="text" name="title" size="40" maxsize="100" /><br />
	     Entry Text: <textarea name="entry" columns="40" rows="5"></textarea></p>
	     <input type="submit" name="submit" value="Add to the Forum!" />
	</form>

also i was wondering if its possible to make a blog scpirt like this that shows the form, shows the other entered blogs, and shows an edit and delete button for each all on the same script. right now i ahve the add and view parts in this script and the delete on the other...no idea if it worx though because i cant test it due to the last error.

[ninjanutz]

and yes, even after spelling action right in the form action the error is still there

[{yak}]

You were missing a couple ending curly braces:

if (isset ($_POST['submit']))
{
    if ($dbc = @mysql_connect ('localhost', 'root', ''))
    {
        if (!@mysql_select_db ('forum'))
        {
            die ('<p>Could not select the database because: <b>' . mysql_error() . '</b></p>');
        }
        $query = "INNSERT INTO forum_entries (blog_id, title, entry, date_entered)
             VALUES (0, '{$_POST['title']}', '{$_POST['entry']}', NOW())";
        if (@mysql_query ($query))
        {
            echo '<p>The blog entry has been added.</p>';
        } else
        {
            echo "<p>Could not add the entry because: <b>" . mysql_error() . "</b>. The query was $query</p>";
        }
    }
} 

mysql_close();

if ($dbc = @mysql_connect ('localhost', 'root', ''))
{
    if (!@mysql_select_db ('forum'))
    {
        die ('<p>Could not select the database because: <b>' . mysql_error() . '</b></p>');
    }

    $query = 'SELECT * FROM forum_entries ORDER BY date_entered ASC';
    if ($r = mysql_query ($query))
    {
        while ($row = mysql_fetch_array ($r))
        {
            echo "<p><h3>{$row['title']}</h3>{$row['entry']}<br />
                 <a href=\"forum.php?id={row['forum_id']}\">Edit</a>
                 <a href=\"delete_entry.php?id={$row['blog_id']}\">Delete</a>
                 </p><hr />\n";
        }
    }
} 
else
{
    die ('<p>Could not retrieve the data because: <b>' . mysql_error() ."'</b>The query was $query</p>");
} 

[ninjanutz]

thought so

[ninjanutz]

long scripts are annoyin with the closing tags lol i always leave 1 out and it makes all the difference

[{yak}]

I always format my code like this:

<?php
if(this == this)
{
	while(some condition)
	{
		if(this == that)
		{
			// do this
		}
	}
}

?>

I'm not saying it's the right way to format your code or anything, but I find it easier to spot such things.

[ninjanutz]

yea mines easier to read but i cant find the missing } i'll try maybe indenting everything but the opening and closing brackets or something

[ninjanutz]

alright it worked now i just gotta run the script that makes a database lol

thanx {yak}

[PlaGuE]

i double space my stuff... and indent "sumtimes" like that.