akiratoya13 Posted April 8, 2008 Share Posted April 8, 2008 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. >_< Quote Link to comment Share on other sites More sharing options...
zenag Posted April 8, 2008 Share Posted April 8, 2008 $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"; } Quote Link to comment Share on other sites More sharing options...
zenag Posted April 8, 2008 Share Posted April 8, 2008 dont need to assign $result... if(mysql_num_rows($sql)==1) use this.. Quote Link to comment Share on other sites More sharing options...
fenway Posted April 8, 2008 Share Posted April 8, 2008 or you could just do a count. Quote Link to comment Share on other sites More sharing options...
gluck Posted April 9, 2008 Share Posted April 9, 2008 select count(*) from tablename where username='name' Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.