killervastu Posted November 10, 2011 Share Posted November 10, 2011 hey guys i am learning php i have a registration code that gives me an error "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pass =' at line 2" i am using wampserver MYSql version 5.1.30 please tell me where the error is <?php include('connect.inc.php'); $error = array(); //---------------------------------------------------------------------- $formname = isset($_POST['formmembername']) ? trim($_POST['formmembername']) : ''; if(empty($formname)) { $error[] = urlencode('Please enter name'); } //---------------------------------------------------------------------- $formsponsorid = isset($_POST['formsponsorid']) ? trim($_POST['formsponsorid']) : ''; if(empty($formsponsorid)) { $error[] = urlencode('Please enter Sponsorid'); } //---------------------------------------------------------------------- $formjoinedunder = isset($_POST['formjoinedunder']) ? trim($_POST['formjoinedunder']) : ''; if(empty($formjoinedunder)) { $error[] = urlencode('Please enter Joined Under'); } //---------------------------------------------------------------------- $formpinnumber = isset($_POST['formpinnumber']) ? trim($_POST['formpinnumber']) : ''; if (empty($formpinnumber)) { $error[] = urlencode('Please enter Pin Number'); } //---------------------------------------------------------------------- $formpinpassword = isset($_POST['formpinpassword']) ? trim($_POST['formpinpassword']) : ''; if (empty($formpinpassword)) { $error[] = urlencode('Please enter Password Of your PIN'); } //---------------------------------------------------------------------- $formposition = isset($_POST['formposition']) ? trim($_POST['formposition']) : ''; if (empty($formposition)) { $error[] = urlencode('Please Select Left or Right'); } //---------------------------------------------------------------------- $formpackage = isset($_POST['formpackage']) ? trim($_POST['formpackage']) : ''; if (empty($formpackage)) { $error[] = urlencode('Please select a package'); } //---------------------------------------------------------------------- $formpassword = isset($_POST['formpassword']) ? trim($_POST['formpassword']) : ''; if (empty($formpassword)) { $error[] = urlencode('Please enter Valid Password'); } //---------------------------------------------------------------------- $formconfirmpassword = isset($_POST['formconfirmpassword']) ? trim($_POST['formconfirmpassword']) : ''; if (empty($formconfirmpassword)) { $error[] = urlencode('Please Confirm Your password'); } //---------------------------------------------------------------------- $formdob = isset($_POST['formdob']) ? trim($_POST['formdob']) : ''; if (empty($formdob)) { $error[] = urlencode('Please enter Date of Birth'); } //---------------------------------------------------------------------- $formpan = isset($_POST['formpan']) ? trim($_POST['formpan']) : ''; if (empty($formpan)) { $error[] = urlencode('Please enter Pan card No.'); } //---------------------------------------------------------------------- $formaddress = isset($_POST['formaddress']) ? trim($_POST['formaddress']) : ''; if(empty($formaddress)) { $error[] = urlencode('Please enter Address'); } //---------------------------------------------------------------------- $formpincode = isset($_POST['formpincode']) ? trim($_POST['formpincode']) : ''; if (empty($formpincode)) { $error[] = urlencode('Please enter pincode'); } //---------------------------------------------------------------------- $formcity = isset($_POST['formcity']) ? trim($_POST['formcity']) : ''; if (empty($formcity)) { $error[] = urlencode('Please enter your City'); } //---------------------------------------------------------------------- $formmobileno = isset($_POST['formmobile']) ? trim($_POST['formmobile']) : ''; if (empty($formmobileno)) { $error[] = urlencode('Please enter Your Mobile No.'); } //---------------------------------------------------------------------- $formemail = isset($_POST['formemail']) ? trim($_POST['formemail']) : ''; if (empty($formemail)) { $error[] = urlencode('Please enter Email'); } //---------------------------------------------------------------------- $formacheck = isset($_POST['formAchek']) ? trim($_POST['formAchek']) : ''; if($formpassword != $formconfirmpassword) { $error[]= urlencode("Password and Conform Password Dosen't Match"); } //---------------------------------------------------------------------- for ($i=1;$i<=7;$i++) { if ($_POST['formpackage']==$i) { $package = $i; } } //check queries----------------------------------------------------- $query_check_join_under = 'SELECT * from memberpd WHERE uniqueid='.$formjoinedunder; $query_check_sponsor_id = 'SELECT * from memberpd WHERE uniqueid='.$formsponsorid; $query_check_pin_and_pass = 'SELECT * from freshepins WHERE epin='.$formpinnumber.'AND pass ='.$formpinpassword; $query_check_lr_not_null = 'SELECT nleft,nright from btree WHERE uniqueid='.$formjoinedunder; $query_check_mobile = 'SELECT * from memberpd WHERE mobile='.$formmobileno; //end check quries=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- //check query result------------------------------------------------ $result_check_join_under = mysql_query( $query_check_join_under , $db ) or die( mysql_error( $db )); $result_check_sponsor_id = mysql_query( $query_check_sponsor_id , $db ) or die( mysql_error( $db )); $result_check_pin_and_pass = mysql_query( $query_check_pin_and_pass , $db) or die( mysql_error( $db )); $result_check_lr_not_null = mysql_query( $query_check_lr_not_null , $db) or die( mysql_error( $db )); $result_check_mobile = mysql_query( $query_check_mobile , $db) or die( mysql_error( $db )); //end check query result=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- if(empty($error)) { $chkjoinunder = mysql_num_rows($result_check_join_under , $db); if($chkjoinunder == 1) { $chksponsorid = mysql_num_rows($result_check_sponsor_id , $db); if($chksponsorid == 1) { $chkpinpass = mysql_num_rows($result_check_pin_and_pass , $db); if($chkpinpass == 1) { $chkmobile = mysql_num_rows($result_check_mobile , $db); if($chkmobile == 1) { $nodelr = array(); $resnodecheckpos = mysql_fetch_assoc($result_check_lr_not_null,$db); $nodelr[0] = $resnodecheckpos['nleft']; $nodelr[1] = $resnodecheckpos['nright']; if($formposition == 'l' && $nodelr[0] == '' || $formposition == 'r' && $nodelr[1] == "") { //enter into memberpd ---------------------------------------------- $insert_memberpd = 'INSERT INTO memberpd (sponsorid,joinedunder,name,address,epin,dob,mobile,email,package,position,pan) VALUES ('.$formsponsorid.','.$formjoinedunder.',"'.$formname.'","'.$formaddress.'",'.$formpinnumber.','.$formdob. ','.$formdob.',"'.$formemail.'",'.$formpackage.','.$formposition.','.$formpan.')'; //---------------------------------------------------------------------- $sql_reguniqueid = 'select uniqueid from memberpd where mobile ='.$formmobileno; $result_reguniqueid = mysql_fetch_assoc($sql_reguniqueid , $db); $reguniqueid = $result_reguniqueid['uniqueid']; //enter into binaryincome ---------------------------------------------- $insert_binary_income = 'INSERT INTO binaryincome (uniqueid) VALUES ('.$reguniqueid.')'; //---------------------------------------------------------------------- //enter into memberlogin ---------------------------------------------- $insert_member_login = 'INSERT INTO memberlogin (uniqueid,password) VALUES ('.$reguniqueid.',"'.$formpassword.'")'; //---------------------------------------------------------------------- //enter into memberincome ---------------------------------------------- $insert_member_income = 'INSERT INTO memberincome (uniqueid) VALUES ('.$reguniqueid.')'; //---------------------------------------------------------------------- //enter into usedepins ---------------------------------------------- $sql_epin_amount='select epinamount from freshepin where asignto ='.$formsponsorid.'AND epin ='.$formpinnumber; $result_epin_amount = mysql_fetch_assoc($sql_epin_amount , $db); $epin_amount = $result_epin_amount['epinamount']; $insert_used_epins = 'INSERT INTO usedepins (epin,usedby,sby,epinamount) VALUES ('.$formpinnumber.','.$reguniqueid.','.$formsponsorid.','.$epin_amount.')'; //--------------------------------------------------------------------- //enter into btree ---------------------------------------------- $sql_plevel='select nlevel from btree where uniqueid='.$joinedunder; $result_plevel = mysql_fetch_assoc($sql_plevel , $db); $plevel = $result_plevel['nlevel'] + 1; $insert_btree = 'INSERT INTO btree (uniqueid,plevel,pside) VALUES ('.$reguniqueid.','.$plevel.','.$formposition.')'; //---------------------------------------------------------------------- if($formposition == 'l') { $update_btree = 'UPDATE btree SET nleft='.$reguniqueid; } if($formposition == 'r') { $update_btree = 'UPDATE btree SET rleft='.$reguniqueid; } $update_fresh_pins = 'DELETE FROM freshepin where epin='.$formpinnumber; } else { $error[]=urlencode('Entered position is already taken'); } } else { $error[]=urlencode('The Mobile number Is already used,Please enter another number'); } } else { $error[]=urlencode('Pin And Password Does not match'); } } else { $error[]=urlencode('Sponsor Id does not Exists'); } } else { $error[]=urlencode('Joined Under Id Does not Exists'); } } else { header('location:join.php?action=register'. '&error=' . join($error , urlencode('<br>'))); } ?> Quote Link to comment Share on other sites More sharing options...
cypher86 Posted November 10, 2011 Share Posted November 10, 2011 is $formpinpassword valorized?? i suggest you put an echo to show that query in order to understand better the problem... echo $query_check_pin_and_pass; Quote Link to comment Share on other sites More sharing options...
killervastu Posted November 10, 2011 Author Share Posted November 10, 2011 is $formpinpassword valorized?? i suggest you put an echo to show that query in order to understand better the problem... echo $query_check_pin_and_pass; Thanks got the error there was no space between id and 'AND' 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.