Jump to content

You have an error in your SQL syntax;

killervastu

By killervastu
in PHP Coding Help

Recommended Posts

killervastu Member

killervastu

Posted
Posted

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 :confused:

<?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>')));
}
?>

Link to comment
https://forums.phpfreaks.com/topic/250869-you-have-an-error-in-your-sql-syntax/
Share on other sites

Archived

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

Go to topic listing
×
×
  • 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.