Help please

[rjliquigan]

okay i wrote this first to enter a username to the database:

$usercheck = $_POST['username'];

$check = mysql_query("SELECT username FROM users WHERE username = '$usercheck'")

or die(mysql_error());

$check2 = mysql_num_rows($check);

 

everything works and writes perfectly to the database. Now i want to change it so instead of username it will be an email so i need to put special characters @ and "." so i used this:

$usercheck = preg_replace("/[^a-zA-Z0-9s]/", "", $usercheck);

it takes out the @ and "." but it wont write to any other tables.

 

Please help, thank you so much!

[Cardale]

I'm a little confused on what your trying to do.

[emopoops]

$emailtest = preg_match("/[^a-z,.\_ -@]/i", $email);
if($emailtest == "1") {contains other characters than the ones specifieis int he prematch()... make them redo