[jigarlives]

Friends,

I have a website with Registration forms created in Php. I want that PHP checks the MySQL db for the FirstName and LastName then lets user know if the name already exists so that user can select different name.

I am using select statement but not able to compare the strings... Please can someone help me with the code to match a form value to a database value....

Also is there some way where one can print the FirstName and LastName on screen from the database.

Thanks.....

[Nico]

I'm not sure what exactly you're doing, and it might be an unlikely event, but two (or more) people can actually have the same name plus last name.

So if I was to sign up on your site, and there's another user who shares the same name, would I be forced to "make up" another name?

Sounds kinda awkward, but if that's what you want.

PHP Code:

$firstname = trim( (string) $_POST['FirstName'] );

$lastname = trim( (string) $_POST['LastName'] );



$query = mysql_query(sprintf("

    SELECT `FirstName`, `LastName`

    FROM `users`

    WHERE `FirstName` = '%s' AND `LastName`  = '%s'

    LIMIT 1",

    mysql_real_escape_string($firstname),

    mysql_real_escape_string($lastname)

) OR die(mysql_error());



if ($user = mysql_fetch_assoc($query))

{

    // User with this name exists

}

else

{

    // NO user found with this name

} 

[mysamsung]

yes i got it right