Touble inserting rows

[Brad]

I would love some help if possible, I'm trying to insert rows into a database from a form but I think something is wrong with my $query and I can't figure it out.

the form is this.....

<form name="post" action="insert.php" method="post">
<b>Post Name</b><input type="text" name="postName"><br><br>
<b>Message</b><textarea rows="10" cols="90" wrap name="message"></textarea>
</font>
<input type="submit" value="Post!"> <input type="reset" value="Reset">

and the script is this.....

<?
if (!$postName || !$message)
{
echo "Form not completely filled in, please post again.";
}

$postName = addslashes($postName);
$message = addslashes($message);

@ $db = mysql_pconnect("some.com", "some.domain.com", "some");
if (!$db)
{
echo "Cannot update database, <a href='newPost.php'>go back</a> and try again!";
}

mysql_select_db("some_domain_com");
$query = "INSERT INTO header (postName, message) VALUES ('$postName','$message')";
$result = mysql_query($query);
if ($result)
{
echo mysql_affected_rows()." message inserted into database.<a href='index.php'>Click here</a> to go back";
}
?>
Is the $query the problem or am I missing something else?

[planetsim]

Try this

$result = mysql_query($query)or die(mysql_error());
It may display an error which i think it will.

[lnxgeek]

At what point does the script cause you problems? Is there any error message produced or just a blank page?

Just thinking outloud:

Always a good idea to nest code.

Use "

" to show your script as highlighted PHP source, helps troubleshoot.

Does <form> accept a name attribute? AFAIK it does not.

I've tried a script prior with a submit button that had the value of "Go!" (with the exclamation point). I remember having problems with the script until I removed it and just made it 'Go'.

I also note you're using global vars, does your server have register_globals enabled? Alot of servers are switching this off as a safety precaution.

mysql_connect parameters are ("servername", "username", "password"), I note you have "some.domain.com" as the username attribute.