[RESOLVED] Insert Problem

[treeleaf20]

I have this code:

$sql = "INSERT INTO `join` (`Email`, `FName`, `LName`, `Password`, `Country`, `Postal`, `bMonth`, `bDay`, `bYear`) VALUES ('$email', '$firstname', '$lastname', '$password', '$country', '$postal', '$bMonth', '$bDay', '$bYear')";

echo $sql;

$result = mysql_result($sql);

Which gives me this when I echo it:
INSERT INTO join (Email, FName, LName, Password, Country, Postal, bMonth, bDay, bYear) VALUES ('[e-mail]', 'fname', 'lname', 'password1', 'US', '99999', '3', '3', '2005')
Warning: Wrong parameter count for mysql_result() in /home/site/public_html/sports/join.php on line 23

The database structure is:
user_id (auto_increment), Email, FName, LName, Password, Country, Postal, bMonth, bDay, bYear so I'm not sure why it gives me the error of parameter count?? Does anyone have any idea why this is?? Thanks for any advice.

I gather all the information from $_POST[ ].

Thanks.

[drew010]

first you have to call [man]mysql_query[/man] and [man]mysql_result[/man] takes a minimum of 2 parameters, the resource link, and the row you want back from the result set.