Jump to content

Check Duplicasy


lovephp

Recommended Posts

guys is this the right way to check if a phone number already exist?

 

////////////////////////////////////Check Phone Exist    
   function phoneNoExist($phoneExist) {
           $sql = "SELECT * FROM table WHERE homenumber='".$phoneExist."'";
           $rs = executeSql($sql);
           if(mysql_num_rows($rs) == 1)
           {
               return true;
           } else {
               return false;
    }
   }

 

i get a error currently which is, say i have already inserted

 

9054567894

 

and when i try to insert another number like

 

9057445671

 

i get number already exist why?

Link to comment
https://forums.phpfreaks.com/topic/270751-check-duplicasy/
Share on other sites

Try this: Echo out your SQL statement to the page, then do a die(); Then execute your SQL statement directly into the database (MySQL Workbench is good for this) and see if you get the error there.

 

////////////////////////////////////Check Phone Exist
 function phoneNoExist($phoneExist) {
				 $sql = "SELECT * FROM table WHERE homenumber='".$phoneExist."'";
die($sql);
				 $rs = executeSql($sql);
				 if(mysql_num_rows($rs) == 1)
				 {
						 return true;
				 } else {
						 return false;
		 }
 }

Link to comment
https://forums.phpfreaks.com/topic/270751-check-duplicasy/#findComment-1393489
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.