How to check for an existing value in mysql

[Markus]

As per usual i'm a newbie.
What i'm struggling with is a sign up script. I need to check whether a username already exists in my MySQL table. I have searched the forums for answers but nothings been explained or answered.

Thanks for the help :)

[pbmods]

Heya, Markus.

Simply SELECT from your database using the information provided and then check to see if your query returned anything:

[code=php]
$_sql = "
SELECT
`id`
FROM
`users`
WHERE
`id` = '{$id}'
LIMIT 1";
$_res = mysql_query($_s ql);

if( mysql_num_rows( $_res) > 0 )
{
// id is taken.
}
mysql_free_resu lt($_res);
[/code]

[ak1dnar]

Moved from Php Articles Section to the Php forum.