Help Please

Nathan__02

i have a comment page and i want it to check if the name and comment is NULL before doing the query...heres what i have so far

<?php
include('config.php');
include("style.css");
$query=mysql_query("INSERT INTO comments VALUES ('','$name','$comment')");
echo("<body background='background3.JPG'><center>");

if ($name ==NULL){
echo("You didn't fill in your name!");
} elseif ($comment ==NULL) {
echo("You didn't have a comment!");
} elseif ($name ==NULL | | $comment ==NULL) {
echo("You didn't fill anything in!");


} elseif($query) {
echo("Comment Added <a href='/stats/comments.php'>Go Back</a>");
} else {
echo("Comment not added, please try again.");
}

echo("</center></body>");

?>

steved

I'd use:

if (!$name && !$comment) {
echo("You didn't fill anything in!");
} else if (!$name){
echo("You didn't fill in your name!");
} else if (!$comment) {
echo("You didn't have a comment!");
} else {
// run the query

Nathan__02

i tried this but it still gets added to the db

<?php
include('config.php');
include("style.css");
$query=mysql_query("INSERT INTO comments VALUES ('','$name','$comment')");
echo("<body background='background3.JPG'><center>");

if (!$name && !$comment) { 
echo("You didn't fill anything in!"); 
} else if (!$name){ 
echo("You didn't fill in your name!"); 
} else if (!$comment) { 
echo("You didn't have a comment!"); 
} elseif($query) {
echo("Comment Added <a href='/stats/comments.php'>Go Back</a>");
} else {
echo("Comment not added, please try again.");
}

echo("</center></body>");

?>

steved

That's because on the third line of your program you are actually running the query.

Nathan__02

so where would i put that

steved

Like I said in my original post:

$query=mysql_query("INSERT INTO comments VALUES ('','$name','$comment')");

}

Nathan__02

thnx it all works fine now