php - 如果数据库中存在一行数据，如何绕过？

Question

我的表包含 ID 和组。

id        group
 1        alpha
 2        beta
 3        omega

我的验证码是:

$validate_query = "SELECT * FROM table_test WHERE id = '{$id}' ";
                $rs = mysql_query($validate_query,$connection);
                if(mysql_num_rows($rs) != 0) {
                    echo "<span class='confirmation'>Oops! Data exist. Try another one.</span>";
                } 
                else { 

                    $query = "UPDATE table_test SET 
                            group= '{$group}'               
                            WHERE id = '{$id}'                      
                            ";
                    $result = mysql_query($query, $connection);  

但我的目标是这样的...

**example:**
if the user want to edit the field group value(ex. alpha) into (beta).. 
then the value of id 1 and 2 is beta... 

现在我只想检查值是否存在..我只想取回原始值(alpha)以便不存在重复...

Answer 1

那么您只需将查询更改为此 -

$validate_query = "SELECT * FROM table_test WHERE group = '{$group}' ";