SQL PHP HTML ASP JavaScript articles and free scripts to download
SQL

Checking for matching record in MySQL table

We can just check MySql table to verify whether a record exist or not. Here we are not interested in collecting the actual data from table. We are interested in getting a reply of TRUE or FALSE from our command. We will try for one line command using PHP.

We need such a query while working on a member signup script. Here when member enters a userid in the signup form we need to verify with our existing table to know if the userid is already used by some other member. Some time we will have different pages with access to different groups of members ( here the members have different level of access ). So when the member visit a page we will check with our table the member has required level of privilege or not.

This conditional checking is done by using if condition in PHP. Let us see the code for checking the userid exist inside a MySQL table or not.

if(mysql_num_rows(mysql_query("SELECT userid FROM plus_signup WHERE userid = '$userid'"))){
// Code inside if block if userid is already there
}

If we are using PDO class then we can use like this
$count=$dbo->prepare("select userid from plus_signup where userid=:userid");
$count->bindParam(":userid",$userid);
$count->execute();
$no=$count->rowCount();
if($no >0 ){
$msg=$msg."User Name already exists. Choose a different User Name";
$status = "NOTOK";     
}
The above sql query will return TRUE or FALSE depending on the presence of userid in MySQL table.

Google+

Omar19-02-2010
Thank you,
That helped Me ..
Vinayak06-03-2010
Thanks, the code solved the bug in my program.
Danoj23-03-2010
Thank you very much for the code, its very important code to all programmers.
Elise02-06-2010
Wauw!! I was searching for this code for hours!! Thank you so much!!
laan08-07-2010
you rule that was exactly what i was looking for 3 second google search and blam on with the programming
Sashko13-07-2010
Awesome! Concise and accurate.
Jan09-12-2010
Thanks, I used to use the mysql COUNT function for this but this is much handier !
Satish Verma03-02-2012
Thanks dear
wow very nice code very useful this code
Cool14-06-2012
Very very usefull script ... Thank you ...
Doug26-06-2012
TOTALLY USEFUL. Exactly what was needed.
Scott21-08-2012
Much more efficient than the count steps I was attempting. Thanks for the post.
Alex15-11-2012
YES YES YES.
After hours of struggling I have found the missing key

mysql_num_rows($query)

THANKS THANKS THANKS
Amanda25-01-2013
Ha! Thank you, had the same problem as Alex.
sidharam anache24-02-2013
very excellent answer.
Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email( not to be displayed)Privacy Policy
1+2=This is to prevent automatic submission by spammers. Please enter the result of the sum as asked



Join Our Email List
Email:  
For Email Newsletters you can trust

HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2014 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer