parse error

here is the script:
<?php
if($submit)
{
$db = mysql_connect("localhost", "root","");
mysql_select_db("learndb",$db);
$sql = "INSERT INTO personnel (firstname, lastname, nick, email, salary)
VALUES ('$first','$last','$nickname','$$result = mysql_query($sql);
echo "Thank you! Information entered.\n";
}
else
{
?>
<form method="post" action="input.php">
First name:<input type="Text" name="first"><br>
Last name:<input type="Text" name="last"><br>
Nick Name:<input type="Text" name="nickname"><br>
E-mail:<input type="Text" name="email"><br>
Salary:<input type="Text" name="salary"><br>
<input type="Submit" name="submit" value="Enter information"></form>
<?
}
?>
---------
here is the error:
Parse error: parse error, unexpected T_STRING in
C:\Inetpub\wwwroot\Projects\doodle\input.php on line 8
......
so what is the deal? yes im a newbie i know its probly sumthin stupid
but thats what use guys are here for right? lolplease help

You have chopped the end off your INSERT statement.

You need the values for email and salary, thus:

$sql = "INSERT INTO personnel (firstname, lastname, nick, email, salary)
VALUES ('$first','$last','$nickname','$email','$salary')" ;

$result = mysql_query($sql);
--
Charles Sweeney
www.CharlesSweeney.com
"mr bungle" <aaron@modnet.com.au> wrote in message
news:3F2D0DFF.7040809@modnet.com.au...
> here is the script:
> <?php
> if($submit)
> {
> $db = mysql_connect("localhost", "root","");
> mysql_select_db("learndb",$db);
> $sql = "INSERT INTO personnel (firstname, lastname, nick, email, salary)
> VALUES ('$first','$last','$nickname','$$result = mysql_query($sql);
> echo "Thank you! Information entered.\n";
> }
> else
> {
> ?>
> <form method="post" action="input.php">
> First name:<input type="Text" name="first"><br>
> Last name:<input type="Text" name="last"><br>
> Nick Name:<input type="Text" name="nickname"><br>
> E-mail:<input type="Text" name="email"><br>
> Salary:<input type="Text" name="salary"><br>
> <input type="Submit" name="submit" value="Enter information"></form>
> <?
> }
> ?>
> ---------
> here is the error:
> Parse error: parse error, unexpected T_STRING in
> C:\Inetpub\wwwroot\Projects\doodle\input.php on line 8
> .....
> so what is the deal? yes im a newbie i know its probly sumthin stupid
> but thats what use guys are here for right? lolplease help
>

Sorry about the top-post there. Happens sometimes!
--
Charles Sweeney
www.CharlesSweeney.com