need help in php

[doforumda]

i have problem with following code.

$namecheck = mysql_query("select * from cv where apply = '$apply' AND name='$name' AND cnic='$cnic' AND email='$email'");
$countname = mysql_num_rows($namecheck);

if($countname != 0)
{
die("You have already applied for this vacancy.<br><br><a href='cv_form.php'>Click Here</a> to go back.");
}

 

what this query does is if all the data in the columns are equal with the data in the variables then the if condition becomes true. what i want is if any of the columns becomes equal then if condition should become true.

 

how to do this?

[mikesta707]

use OR instead of AND