mysql query in zend framework need some hint

i have an query in mysql zend framwork is there any other way of writing this

$select = $this->select ()
               ->where ( "phone =  '" . $post ['phone'] . "'")
               ->w开发者_Go百科here(!( "member_id != '" .$post['member_id'] . "'"));

what am trying to do is update phone no of member and see if the phone no already exist in datbase any other way of doing this can someone answer

First off, your code has a security issue. Always use safe quoting:

->where("phone = ?",$post["phone"])

As for the question, you can use the Zend_Validate_Db_NoRecordExists validator on your form. Here are some useful links:

• http://framework.zend.com/manual/en/zend.validate.set.html#zend.validate.Db
• http://framework.zend.com/issues/browse/ZF-8012

The idea of using this validator is precisely checking whether a given value doesn't already exist in the database, without any additional work on your queries.

To do this I suggest you use a validator on the form!

Example Form:

        //phone
    $this->addElement('text', 'phone',
                      array('label' => 'Phone', 'required' => true));
    $params = array(
        'table' => 'User',
        'field' => 'phone',
    );
    $this->phone->addValidator('Db_NoRecordExistPhone', false, array($params));

validator write in the query that will return the control should be true or false.