MYSQL Check Database

[akiratoya13]

MYSQL version is 1.4

Hi guys, I want to search if any data that have been added to my database.

I tried all ways in the book and tried my self.. But I couldn't do that..

 

example:

a member has username akira.

Now a new guest want to be a member with the same name ( akira )..

I want to check my database if there is any username akira..

What statement I need? Thanks.. Sorry if it's a beginner question.. But I'm really confuse about it. >_<

[zenag]

$sql=mysql_query("select * from tablename where username='$_post["username"]'");

if($result=mysql_num_rows($sql)==1)

{

$rand=rand(0,9);

echo "username already exists";

echo "you can use $_post["username"].$rand ";

}

else

{

echo "not exists";

}

[zenag]

 

dont need to assign $result...

if(mysql_num_rows($sql)==1)

use this..

[fenway]

or you could just do a count.

[gluck]

select count(*) from tablename where username='name'