how to check in the databse

[webandwe]

Hi,

I have 1 field where you enter a username and then it post to the next page, get mysql data and do what ever.

It there a small script or a sort code that I can add, for if someone types in a username and the username does not exist in mysql the page echo out "user does not exists, please click back")?

So anything that I can put on the page after someone submitted something that checks will be great, thanks.

Kind Regards
Louwrens

[pbmods]

Heya, Louwrens.

$__sql = "
SELECT
        1
    FROM
        `table`
    WHERE
        `username` = '{$__escapedUsername}'
    LIMIT 1";
 
$__res = mysql_query($__sql);
 
if( mysql_num_rows($__res) > 0 )
{
    // User exists.
}
else
{
    // User does not exist.
}
mysql_free_result($__res);