code no adding

[ecabrera]

i dont get whats wrong i does not add to the db

 

<?php

if($_POST['submitbtn']){

require "scripts/connect.php";

$title = mysql_real_escape_string($_POST['title']);
$by = mysql_real_escape_string($_POST['by']);
$body = mysql_real_escape_string($_POST['body']);

if ($title && $by && $body){

$query = mysql_query("INSERT INTO news (title, by, body)VALUES('$title', '$by', '$body')");

echo "ADD SUCCESFULLY!";

}else
   $msg = "<font color=red>YOU DID NOT FILL ALL OF THEM IN!</font>";
}

?>

[masterkip]

What showing this code?

<?php

if($_POST['submitbtn']){

    require "scripts/connect.php"; // check content of this file

    $title = mysql_real_escape_string($_POST['title']);
    $by = mysql_real_escape_string($_POST['by']);
    $body = mysql_real_escape_string($_POST['body']);

    if ($title && $by && $body){

        mysql_query("INSERT INTO news (title, by, body)VALUES('$title', '$by', '$body')") or die(mysql_errno()); // if mysql_query() wrong, printing mysql_errno()

        echo "ADD SUCCESFULLY!";

    }else
        $msg = "<font color=red>YOU DID NOT FILL ALL OF THEM IN!</font>";
}


?>