php - 用于检查重复条目的 SQL OR 条件

Question

伙计们，我需要一点帮助。我需要检查数据库中是否有重复的条目。我需要检查重复的电话条目或重复的电子邮件条目。这是sql。这是对的吗？因为它不起作用。

if(isset($_POST['submit']))
            {
                foreach($_POST as $key=>$val)
                ${$key}=addslashes($val);

                $contdupcheck = "select * from `contact` where `email` = '$email' OR `phone` = '$phone'";
                $contdupresult = mysql_query($contdupcheck);
                if(mysql_num_rows($contdupresult)==2)
                {
                    ?>
                    <script type="text/javascript">         
                    notification('You have already sent something twice!','error');
                    </script> 
                    <?php
                } 
                else 
                {

                    $contquery = "INSERT INTO `contact` (`name`, `email`, `phone`, `message`) VALUES ('$name', '$email', '$phone', '$contmessage')";
                    $contresult = mysql_query($contquery);
                    if($contresult)
                    {
                        ?>
                        <script type="text/javascript">         
                        notification('Thank you for your message!','success');
                        </script>           
                        <?php
                    }
                    else 
                    {
                        ?>
                        <script type="text/javascript">         
                        notification('There was an error. Please try after some time!','error');
                        </script>  
                        <?php
                    }
                }
            }

Answer 1

Just divide your query in two parts AS @suchit said

$contdupcheck = "select * from `contact` where `email` = '$email' OR `phone` = '$phone'";
   REPLACE IN TO

$contdupcheck = "select * from `contact` where `email` = '$email'";
$contdupcheck1 = "select * from `contact` where `phone` = '$phone'";
 $contdupresult = mysql_query($contdupcheck);
 $contdupresult1 = mysql_query($contdupcheck1);
AND NOW MATCH
 if(mysql_num_rows($contdupresult)==2 || mysql_num_rows($contdupresult1)==2)