already put the validation..it will prompt user the errors..but it query into database also how can i solved it??

<table width="1000" height="95" border="1">

<tr>

<td bgcolor="#0000FF">&nbsp;</td>

</tr>

</table>

<?php


include("connect.php");

//this is your validation in the form,put it here....

if (empty($_POST['name']))

{

$errors[] = 'Please enter a name';

}

if (empty($_POST['email']))

{

$errors[] = 'Please enter a valid e-mail address';

}

else if (!eregi("^[_a-z0-9-]+(.[_a-z0-9-]+)*@[a-z0-9-]+(.[a-z0-9-]+)*(.[a-z]{2,3})$",

$_POST['email']))

{

$errors[] = 'Please enter a valid e-mail address';

}

if (empty($_POST['contact']))

{

$errors[] = 'Please enter a valid contact with numeric value';

}

else if (!is_numeric($_POST['contact']))

{

$errors[] = 'Please enter a valid contact with a numeric value';

}

if (empty($_POST['person_attend']))

{

$errors[] = 'Please enter some word for person attend';

}

 

 

else if (strlen ($_POST['person_attend']) > 255)

{

$errors[] = 'person attend';

}


if (empty($_POST['comment']))

{

$errors[] = 'Please enter some comment';

}

else if (strlen ($_POST['comment']) > 255)

{
$errors[] = 'comment ';

}
$name = $_POST['name'];
$email = $_POST['email'];

$contact = $_POST['contact'];
$person_attend = $_POST['person_attend'];

$comment = $_POST['comment'];

if($name="" && $email="" && $contact="" && $person_attend="" && $comment="" )

$name = $_POST['name'];
$email = $_POST['email'];
$contact = $_POST['contact'];
$person_attend = $_POST['person_attend'];
$comment = $_POST['comment'];

$query = "INSERT INTO rsvp (id, name, email, contact, person_attend, comment)
VALUES ('', '$name', '$email', '$contact', '$person_attend', '$comment')";

$results = mysql_query($query) or die 
("Could not execute query : $query." . mysql_error());

{

if(isset($errors))
{
foreach($errors as $val)
{
echo "Error: $val <br>";
}
}
{
echo "Thanks for join us.";
}
}



{

mysql_close();
}

?>


<a href="Index.php">View list attend</a>

Try this.

<table width="1000" height="95" border="1">

<tr>

<td bgcolor="#0000FF">&nbsp;</td>

</tr>

</table>

<?php


include("connect.php");

//this is your validation in the form,put it here....

if (empty($_POST['name']))

{

$errors[] = 'Please enter a name';

}

if (empty($_POST['email']))

{

$errors[] = 'Please enter a valid e-mail address';

}

else if (!eregi("^[_a-z0-9-]+(.[_a-z0-9-]+)*@[a-z0-9-]+(.[a-z0-9-]+)*(.[a-z]{2,3})$",

$_POST['email']))

{

$errors[] = 'Please enter a valid e-mail address';

}

if (empty($_POST['contact']))

{

$errors[] = 'Please enter a valid contact with numeric value';

}

else if (!is_numeric($_POST['contact']))

{

$errors[] = 'Please enter a valid contact with a numeric value';

}

if (empty($_POST['person_attend']))

{

$errors[] = 'Please enter some word for person attend';

}

 

 

else if (strlen ($_POST['person_attend']) > 255)

{

$errors[] = 'person attend';

}


if (empty($_POST['comment']))

{

$errors[] = 'Please enter some comment';

}

else if (strlen ($_POST['comment']) > 255)

{
$errors[] = 'comment ';

}
$name = $_POST['name'];
$email = $_POST['email'];

$contact = $_POST['contact'];
$person_attend = $_POST['person_attend'];

$comment = $_POST['comment'];

if($name="" && $email="" && $contact="" && $person_attend="" && $comment="" ) {
	if(isset($errors))
	{
		foreach($errors as $val)
		{
			echo "Error: $val <br>";
		}
	}
} else {

$name = $_POST['name'];
$email = $_POST['email'];
$contact = $_POST['contact'];
$person_attend = $_POST['person_attend'];
$comment = $_POST['comment'];

$query = "INSERT INTO rsvp (id, name, email, contact, person_attend, comment)
VALUES ('', '$name', '$email', '$contact', '$person_attend', '$comment')";

$results = mysql_query($query) or die 
("Could not execute query : $query." . mysql_error());
echo "Thanks for join us.";
mysql_close();
}
?>


<a href="Index.php">View list attend</a>

One suggestion. Look at how loops, conditions, { } works. You have { } all over the place.

This question has already been answered. Start a new discussion instead.