returning mysql_numrows results via php class problem

[fimbria]

hello,

im using a PHP class to deal with the queries that my web site needs. The problem im having is that i need to return a mysql_numrows results, but the code i am using will not work.
The code is as follows:

***external php class ********

function checkAddMailing($email)
{
$query = mysql_query("SELECT email FROM mailing WHERE email='$email'") or die(mysql_error());
$rs = mysql_num_rows($query);
return $rs;

 }

* mailing page **********

                include "external.php";

                //make an object of the wrapperclass
                $forum=new Interface();

                //make db connection
                $forumpointer=$forum->connect();

                //get records
                $rs = $forum->checkAddMailing($email);

                //disconnect to db
                $forum->Disconnect($forumpointer);

                          if ($rs !=0)  {
                          }else{
                          echo "The email address you entered already exists in our mailing list!<br>\n";
                     }

Hope its something simple, i've overlooked

Thanks for any help in advance

[bubblenut]

Looks like it could be a register globals problem. Where do you get the $email value from and are you sure it's not empty?
A little debuging code would probably give you a better idea of what's going on.

#******external php class ***********

function checkAddMailing($email)
{
  $sql="SELECT email FROM mailing WHERE email='$email'";
  echo('$sql: '.$sql."<br />\n");
$query = mysql_query($sql) or die(mysql_error());
$rs = mysql_num_rows($query);
return $rs;

}

#**** mailing page *************


include "external.php";

//make an object of the wrapperclass
$forum=new Interface();

//make db connection
$forumpointer=$forum->connect();

//get records
$rs = $forum->checkAddMailing($email);
echo('$rs: '.$rs."<br />\n");

//disconnect to db
$forum->Disconnect($forumpointer);

if ($rs !=0) {
}else{
echo "The email address you entered already exists in our mailing list!<br>\n";
}

HTH
Bubble