[zitwep]

Hey,

I am building a registration form and so far coming along great, but now i am stuck in front of something i have never really worked before yet.

Before people register i somehow have to check the database for the email and username they submitted so no double registrations occur. But I have no idea once i got the array with all usernames by for example

Code:

SELECT user_name FROM login_table

how to check if the provided username is in this error.

Can someone help me and point me in the right direction please?

Thanks for your help as usual
zitwep

[Nico]

PHP Code:

<?php



$query = mysql_query("SELECT * FROM user_table WHERE user_name = '". $username ."' OR email = '". $email ."'");



if (mysql_num_rows($query) > 0)

{

     echo 'Username or email already in use.';

}



?>

Untested but should work.

[zitwep]

Ok that did it,

thank you a lot for your great help on these forums

Greetz
zitwep

[moeenakhtar]

hi ...........dear did u checked this code???

if user entered the email address like example@hotmail.com and example@Hotmail.com is already stored in db.

it will be allowing user to signup with the same id, but i think it should not allow to signup!!! I am facing this problem. Kindly Help

[Nico]

Are you sure? MySQL SELECT queries are case insensitive, so that shouldn't be a problem, unless you do something that I don't in my code.