Form validation

[raouleduke]

ON my form submit page, I want to do one of two things, based on whether or not a field is set to a certain value. It is the if statement that I want to set by, Here is the code:

<?php

$RO = $_POST['RO']; 
$FollowUpContact = $_POST['FollowUpContact']; 
$CustomerNotReached = $_POST['CustomerNotReached']; 
$Q1 = $_POST['Q1']; 
$Q2 = $_POST['Q2']; 
$Q3 = $_POST['Q3']; 
$Q4 = $_POST['Q4']; 
$Q5 = $_POST['Q5']; 
$LaborCode = $_POST['LaborCode']; 
$Comments = $_POST['Comments']; 
$HAPPY = $_POST['HAPPY']; 

mysql_connect(""); 
mysql_select_db(""); 
if($CustomerNotReached=0){
$query = "UPDATE KEYCAD SET Hold='Y', FollowUpContact='$FollowUpContact', CustomerNotReached='$CustomerNotReached', Q1='$Q1', Q2='$Q2', Q3='$Q3', Q4='$Q4', Q5='$Q5', LaborCode='$LaborCode', Comments='$Comments', HAPPY='$HAPPY' WHERE RO=$RO";
}else{
$query = "UPDATE KEYCAD SET Hold='N', FollowUpContact='$FollowUpContact', CustomerNotReached='$CustomerNotReached', Q1='$Q1', Q2='$Q2', Q3='$Q3', Q4='$Q4', Q5='$Q5', LaborCode='$LaborCode', Comments='$Comments', HAPPY='$HAPPY' WHERE RO=$RO";
}
print $query."<br />"; 
$result = mysql_query($query) or die(mysql_error());
echo"Thank You! Information Updated.\n";

?>

Thanks in advance for any help

[diego25]

To compare, you use == instead of =.

if($CustomerNotReached==0){

Diego

[raouleduke]

Thank you for the reply but just figured it out a minute ago.
I appreciate your help.

[Scurvy]

I have a similar question about this.
I have a form that emails a confirmation to the form filler and one to the admin. I need to have the admin emailed to two different places based on the country the filler submits. Can this statement:

if($CustomerNotReached==0)

be

if($country==USA, Mexico, etc){
$to1
}else{
if($country==Canada){
$to2

or something similar? Or does each country need it's own if() ?
And if not, what would be an example of the proper script?

Thanks all,
Scurvy

[RedDragon]

you can do

if($country=='USA' || $country=='Mexico') {

[Scurvy]

Well, I'm trying but I keep getting a parse error when I code this part.

 // Begin Mail Action

$to = "{$_POST['firstname']} {$_POST['lastname']}<{$_POST['email']}>" . ", " ; 
$to1 = "Jeff<[e-mail]>";
$to2 = "Jay <[e-mail]>";

  // subject
$subject = "Request for information";

  // Customers email message
$message = 'blah blah blah';



  // and now mail it

mail($to, $subject, $message, $headers);
if($country=="USA"){
mail($to1, $subject, $message1, $headers);
}else{
if($country=="Canada"){
mail($to2, $subject, $message1, $headers);
}


  // End Mail Action

else{

echo "Insert failed";

} else{ <------- Here is the parse error ------


  // display html and form

  ?>

What I want is for $to to go to the submitter regardless of country (it's a response for submitting).
$to1 and $to2 will depend on the country entered in the form.
USA goes to $to1 and Canada goes to $to2. There will also be
others. USA, Mexico go to $to1. Canada, European countries
will go to $to2, Australia and others will go to $to3, etc.
Is this possible or is there a better way?
If you need the full code let me know. It's kind of long as all
this stuff is in one page.

[devinemke]

store the different country groupings into separate arrays and use in_array() to check which group the submitted country belongs to. use the result to decide which $to's to use in your email code.

[Scurvy]

Thanks for the help Devin. I've moved this to a new topic though as it is no longer about the subject (Form Validation). Check 'multiple arrays, in_arrays and email?' for the continuation.
BTW - The in_arrays work great. Check the other topic for my next question 🙂