Insertion In database problem

[killervastu]

	//enter into btree ----------------------------------------------
								$sql_plevel='select nlevel from btree where uniqueid = '.$formjoinedunder;
								$abc = mysql_query($sql_plevel , $db)
								$result_plevel = mysql_fetch_assoc($abc) or die(mysql_error());
								$plevel = $result_plevel['nlevel'] + 1;
								$insert_btree = 'INSERT INTO btree (uniqueid,nlevel,pside) VALUES 
								('.$reguniqueid.','.$plevel.','.$formposition.')';
								 mysql_query($insert_btree , $db) or die(mysql_error());

 

Can any one please tell me what is the problem in the above code it does not insert into the table btree.

[killervastu]

$abc = mysql_query($sql_plevel , $db);

  ; was not added but it still dosen't work

[ReeceSayer]

I'm still a learner too so this might not be right but:

 

//enter into btree ----------------------------------------------
								$sql_plevel='select nlevel from btree where uniqueid = '.$formjoinedunder;
								$abc = mysql_query($sql_plevel , $db)
								$result_plevel = mysql_fetch_assoc($abc) or die(mysql_error());
								$plevel = $result_plevel['nlevel'] + 1;
								$insert_btree = 'INSERT INTO btree (uniqueid,nlevel,pside) VALUES 
								('$reguniqueid', '$plevel', '$formposition')';
								 mysql_query($insert_btree , $db) or die(mysql_error());

 

Not sure you needed the .$value. in the query? I've looked at some i've done before and they just have the values as they are above.

 

Can always try it.

 

Cheers

[killervastu]

Problem Is solved I don't Know how but its working good