superdude Posted August 24, 2006 Share Posted August 24, 2006 I am trying to make a form that certain fields will be checked against the data in mysql, this is to avoid duplicates. Below is the code I am trying to use. It is to verify that a phone number is not already in database. i first checked that it was there, and then i tried to check it against the database, however it is simply going to my not uploaded warning. What can I do? Is there maybe a better way to do this? as this is one of many checks like this. Note: this is not a primary nor will be.if(empty($_POST['home_phone'])){$errors[]='Home Phone Required'; }else{ $hp=trim($_POST['home_phone']); } if($hp){ //connects to databse require_once('./db_config.php'); $hpq="SELECT home_phone FROM leads where home_phone='$hp'"; $hpresult= mysql_query($hpq) or trigger_error("Query: $hpq\n<br/>MYSQL Error:".mysql_errno()); if (mysql_num_rows($hpresult)==0){$home_phone=trim($_POST['home_phone']);}Else{ $errors[]='Duplicate Lead';} ;} //If no errors if(empty($errors)) Link to comment https://forums.phpfreaks.com/topic/18570-checking-data-in-mysql-before-an-insert/ Share on other sites More sharing options...
mr. big Posted August 24, 2006 Share Posted August 24, 2006 This part looks good to me. I'm pretty much a noob but I use a nearly identical code, only the last line of mine makes the insertion query using $hp instead of giving $_POST['home_phone'] a second variable name.Might be in another part of the code. Link to comment https://forums.phpfreaks.com/topic/18570-checking-data-in-mysql-before-an-insert/#findComment-79997 Share on other sites More sharing options...
superdude Posted August 24, 2006 Author Share Posted August 24, 2006 Here is the coding modified a bit, still no better result. Seems to always come up an error, even when one does not exsist. Hmmmmm... //home phone if(empty($_POST['home_phone'])){$errors[]='Home Phone Required'; }else{ if($_POST['home_phone']);{ //connects to databse require_once('./db_config.php'); $hpq="SELECT home_phone FROM leads where home_phone='$home_phone'"; $hpresult= mysql_query($hpq) //or trigger_error("Query: $hpq\n<br/>MYSQL Error:".mysql_errno()) ;} if(mysql_num_rows($hpresult)==0){ $home_phone=trim($_POST['home_phone']);}Else {$errors[]='Duplicate Lead';} } Link to comment https://forums.phpfreaks.com/topic/18570-checking-data-in-mysql-before-an-insert/#findComment-80013 Share on other sites More sharing options...
fenway Posted August 28, 2006 Share Posted August 28, 2006 An error how? Link to comment https://forums.phpfreaks.com/topic/18570-checking-data-in-mysql-before-an-insert/#findComment-81856 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.