OK, I'm 100% new to php. I won't even lie. I'm creating a very basic, insecure guestbook. Having troubles though.
http://codingasylum.freehostia.com/g.../guestbook.htm

<?php
if(isset($_POST['process']) && $_POST['process']==1)
{
$con = mysql_connect("XXXXX","XXXXXXXX","XXXXXXX");
if(!$con)
{
    die("Connection Failed" . mysql_error());
}

mysql_select_db("guestbook", $con);

$query ="INSERT INTO guestbook
(email, message, ip, date)
VALUE  //THIS IS WHERE MY PROBLEM IS!!!!
('$_POST[email]','$_POST[message]','$_SERVER['REMOTE_ADDR'], NOW())";

if(mysql_query($query))
{
    echo "Success!";
}
else
{
    echo "Failed";
}

}
else
{
    echo "Denied Access!";
}
mysql_close($con);
?>

http://dev.mysql.com/doc/refman/5.1/en/insert.html

PHP Code:

$email = $_POST['email']; //validate this
$msg = $_POST['message']; //validate this too
$addr = $_SERVER['REMOTE_ADDR'];

$query = "INSERT INTO guestbook (email, message, ip, date)
                    VALUES( '$email' , '$msg' , '$addr' , NOW());"; 


You were using VALUE not VALUES, also $_SERVER['REMOTE_ADDR'] won't be parsed in quotes ($_SERVER[REMOTE_ADDR] will).
Personally I try to stay away from parsing complex variables (ie arrays) in quotes.

Personally I try to stay away from parsing complex variables (ie arrays) in quotes.

Or embed them between { and }

PHP Code:

$query ="INSERT INTO guestbook
(email, message, ip, date)
values
('{$_POST['email']}','{$_POST['message']}','{$_SERVER['REMOTE_ADDR']}', NOW())"; 


$query ="INSERT INTO guestbook
(email, message, ip, date)
VALUES
('".$_POST[email]."', '".$_POST[message]."', '".$_SERVER['REMOTE_ADDR']."', NOW() )";

syntax fixed... still won't work... Maybe because of the remote addr and the now()?

What is the error, and what is your table structure?

For some reason it didn't like it when i did.
mysql_select_db(db,$con);
So i did it without the $con and bam! thanks all for the help.