[fw-db] FetchAll Problem

Hello all

 

I am trying to create a registration form with ZF1.8. After user enters his email, I want to check whether that email address is already registered or not. But everytime I am having a MySQL synax error.

 

The code is

if($form->isValid($formData))

            {

                        $alumniName = $form->getValue('alumni_Name');

                        $alumniLastName = $form>getValue('alumni_LastName');

                        $alumniEmail = $form->getValue('alumni_Email');

                        $alumniPassword = $form->getValue('password');

                        $alumniGraduateDate = $form->getValue('alumni_GraduateDate');

                        $alumniMemory= $form->getValue('alumni_Memory');

                        $alumni = new Model_DbTable_Alumni();

                        $row = $alumni->fetchAll(' alumni_Email = ' . $alumniEmail);

                        if(count($row>0))

                        {

                             throw new Exception('This email is already registered');

                        }

                        else {

                             $alumni->registerAlumni($alumniName,$alumniLastName,$alumniEmail,$alumniPassword,$alumniGraduateDate,$alumniMemory);

                        }

                       

                       

            }

            else {

                  $form->populate($formData);

                 

            }

 

The error I am having is

Message: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@gmail.com) LIMIT 1' at line 1

 

I have lots queries running the same way. Is there any problem in the code that you can see but I can not..

 

Regards

E