doforumda Posted October 21, 2009 Share Posted October 21, 2009 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? Quote Link to comment https://forums.phpfreaks.com/topic/178419-need-help-in-php/ Share on other sites More sharing options...
mikesta707 Posted October 21, 2009 Share Posted October 21, 2009 use OR instead of AND Quote Link to comment https://forums.phpfreaks.com/topic/178419-need-help-in-php/#findComment-940890 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.