select doesnot work if argument in WHERE includes numbers

[strangermaster]

Hi !

 

if i check email and it has no numbers it is ok but if it has it doesnot find user but user exists of course, can you help?

 

 

This is my function :

public function getClientId($find)

{

 

if (is_numeric($find))

{

$sql = "SELECT idmembre FROM b_membres WHERE idmembre='$find'";

$result = $this->cxn->query($sql);

 

if($result->num_rows == 1)

return $find;

else

return false;

}

 

 

 

else

{

$sql = "SELECT idmembre FROM b_membres WHERE email='$find'";

$result = $this->cxn->query($sql);

 

if($result->num_rows == 1)

{

$row=$result->fetch_assoc();

}

return $row['idmembre'];

}

 

 

 

return false;

}

[fenway]

What does "Includes numbers" mean?  Echo $sql.

[strangermaster]

sorry : ex [email protected] will not pass throught

[strangermaster]

SELECT idmembre FROM b_membres WHERE email='[email protected]'

[fenway]

Shouldn't be anything wrong with that at all...