validation check before mail form?

[yuan]

i tried to check the result from database and get the result back... after that use mail method.. the problem is it will mail for me many by once time, how can i solve it??

my coding like:

$query = "select username from data where username=$_GET[name]";
if(mysql_query($query)) {
echo "Your username was found";
} else {
mail("[e-mail]", $subject, $content, $from);
}

[vasah20]

I'm a little confused with your question.

Are you saying that your code will end up emailing you many times, or will only email you once?

Maybe I can help once that's cleared up.

[yuan]

i mean that my mailbox will received "many" same mail from that php code.....so how to solve it??

[driverdave]

Please change this

$query = "select username from data where username=$_GET[name]";

to this

$query = "select username from data where username='".addslashes($_GET[name])."'";

Your original code allows people to modify your SQL query based on their input.

[xblue]

that could either be a good advice (if magic quotes are off) or a bad one (if magic quotes are on). however, isn't this somewhat off topic with respect to the problem?