mySQL Help...

[Akujin]

I got most of this from a friend and out of a book... If any of you can see my problem that would be wonderful.

<?

error_reporting(E_ALL);

$auth = $POST["auth"];
$story = $POST["story"];

if (!$auth || !$story) {

echo "<center>You did not fill out everything!</center>";
exit;

}
else {

                 $database = mysql_connect("localhost", "user", "pass") or die("Could not connect to the database!);


                 mysql_select_db("akujin") or die("Cannot select the database!!");
                 $query = "INSERT INTO stories values ('".$auth."', '".$story."')";
                 $result = mysql_query($query);

                       if ($result)       {

                          echo "<center>Thank you for submitting your story</center>";

                       }

 }

?>

note: pass and user have been changed from there origional to summit else

[LordShryku]

What's the problem?

[LordShryku]

Well, only thing I see is a missing "

$database = mysql_connect("localhost", "user", "pass") or die("Could not connect to the database!");

[Akujin]

Heh... It dosnt insert into the database... Thats what the problem is. It gives me a blank page to instead of the query results...

That " could be the hole problem thanks

[ramkumar_unknow]

According to Mysql documentation, Mysql_query returns zero when successful and non-zero values when failure.
so u have to say

if(!$result){
echo "<center>Thank you for submitting your story</center>";
}

[Akujin]

o.O It works withought that though O.o