[RESOLVED] Using -ve in the if stmt

[habbardone]

Hello,

This is a bit basic but just wanted to check with someone that its correct :o

If the two variables are BOTH not empty then the INSERT should happen, otherwise skip it.

if(!$N_contact1 == "" && !$N_email1 == ""){  		
		$sql = "INSERT INTO freinds (f_name, f_email, up_name, up_email, create_date) 
		VALUES ('$N_contact1','$N_email1','$N_contact','$N_email','$today')";

	 mysql_query($sql)
	 or die("could not execute CLIENT INSERT query");
} // end if

Not sure about my if stmt.

Thanks for any guidance.

[wilku]

I don't know if it would work but I would write it like this:

if(!empty($N_contact1) && !empty($N_email1))

if you want to be sure that both variables are not only spaces (as empty would return false then) [man]trim[/man] the variables before checking - but not like this: empty(trim($variable)).

[Joseph07]

Use empty.

if (!empty($N_contact1) && !empty($N_email1)

[habbardone]

Thanks guys 🙂