[SOLVED] what's wrong with this function?

[ok]

I have this function below,

 

and the last query which is UPDATE don't work

 

here is the function.

function insert_invited($ufull_name, $ffull_name, $INV_referer2) {
		$query = "SELECT * FROM users WHERE user_name='$ufull_name'";
		$result = mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());
		$row = mysql_fetch_array($result);
		$USERS_userid = $row['user_id'];		
		$USERS_username = $row['user_name'];

		$query = "INSERT INTO invited (user_id, referer_name, invited) VALUES ('.$USERS_userid.', '$ufull_name', '$ffull_name')"; 
		mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());

		$query = "SELECT * FROM invited WHERE invited='$ufull_name'";
		$result = mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());
		$row = mysql_fetch_array($result);
		$INV_referer2 = $row['referer_name'];	
		$INV_invited2 = $row['invited'];

		echo "<br><b>inv_referer2: <b>", $INV_referer2;
		echo "<br><b>ufull_name: <b>", $ufull_name;
		echo "<br>";

		//update user_join
		$query = "UPDATE user_join SET invited_by='$INV_referer2' WHERE user_name='$ufull_name'"; 
		mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());

}

 

why?

 

thank you in advance.

 

[ok]

ok for clarification this are the complete codes,

 

process.php

<?php
//open connection and assign variables.
include 'opendb.php';
$tmp_dir = 'http://' . $_SERVER['HTTP_HOST'] . '/contest.php?';

//catching the values.
$ufname = $_POST['ufname'];
$ulname = $_POST['ulname'];
$uemail = $_POST['uemail'];
$ffname = $_POST['ffname'];
$flname = $_POST['flname'];
$femail = $_POST['femail'];

$faces = '';

$space_tmp = ' ';
$ufull_name = $ufname . $space_tmp . $ulname;	//referer
$ffull_name = $ffname . $space_tmp . $flname;	//referred
?>

<?php
//define functions.
function insert_invited($ufull_name, $ffull_name) {
		$query = "SELECT * FROM users WHERE user_name='$ufull_name'";
		$result = mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());
		$row = mysql_fetch_array($result);
		$USERS_userid = $row['user_id'];		
		$USERS_username = $row['user_name'];

		$query = "INSERT INTO invited (user_id, referer_name, invited) VALUES ('.$USERS_userid.', '$ufull_name', '$ffull_name')"; 
		mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());

		$query = "SELECT * FROM invited WHERE invited='$ufull_name'";
		$result = mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());
		$row = mysql_fetch_array($result);
		$INV_referer2 = $row['referer_name'];	
		$INV_invited2 = $row['invited'];

		echo "<br><b>inv_referer2: <b>", $INV_referer2;
		echo "<br><b>ufull_name: <b>", $ufull_name;
		echo "<br>";

		//update user_join
		$query = "UPDATE user_join SET invited_by='$INV_referer2' WHERE user_name='$ufull_name'"; 
		mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());

}
?>

<?php
//verify for duplicate records in USERS table.
//if duplicate exist then don't insert, else insert the record.
$query = "SELECT * FROM users WHERE user_name='$ufull_name'";
$result = mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());
$row = mysql_fetch_array($result);
$USERS_username = $row['user_name'];

$query = "SELECT * FROM invited WHERE invited='$ufull_name'";
$result = mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());
$row = mysql_fetch_array($result);
$INV_referer = $row['referer_name'];
$INV_invited = $row['invited'];

$query = "SELECT * FROM invited WHERE invited='$ffull_name'";
$result = mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());
$row = mysql_fetch_array($result);
$INV_referer2 = $row['referer_name'];	
$INV_invited2 = $row['invited'];


if($ufull_name == $USERS_username) {
	if($ufull_name == $INV_invited && $INV_referer == $ffull_name) { 				
		//updaet user_join table.
	} elseif($INV_invited2 != $ffull_name) {
		insert_invited($ufull_name, $ffull_name, $INV_referer2);
	}
} elseif($ufull_name == '') {		
	if($ufull_name == $INV_invited && $INV_referer == $ffull_name) { 				
		//do nothing.
	} elseif($INV_invited2 != $ffull_name)  {
		insert_invited($ufull_name, $ffull_name, $INV_referer2);
	}
} else {
	//insert record into users table if duplicate not found.
	//insert record into invited table if duplicate not found.		
	$query = "INSERT INTO users (user_name, email, faces, date_join) VALUES ('$ufull_name', '$uemail', '$faces', now())"; 
	mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());

	/*
		echo "user: ", $USERS_userid;
		echo "<br><b>ufullname:</b> ", $ufull_name;
		echo "<br><b>INV_invited:</b> ", $INV_invited;
		echo "<br><br><b>ffullname:</b> ", $ffull_name;
		echo "<br><b>INV_referer:</b> ", $INV_referer;
	*/

	//if the referer is not yet invited, then add record to INVITED table, else deny.
	#if($ufull_name == $INV_invited && $INV_referer == $ffull_name) { 		
	if($ufull_name == $INV_invited && $INV_referer == $ffull_name) { 				
		//do nothing.
	} elseif($INV_invited2 != $ffull_name)  {
		insert_invited($ufull_name, $ffull_name, $INV_referer2);
	}
}

?>

 

 

[ok]

ok this problem is solved.

 

i figured it out.

 

it's my stupid structure of the program itself that i created.