function call

twb

Hi I am having a problem when calling a function. I have a function that populates numerous text boxes and echos the querry that was used displaying the employee_id...This all works. The problem is when I go to update it the same function is called and it cant find that employee_id... The function is still called..

function Display_Employee_Details($employee_id){
$query = "Select * FROM employees WHERE employee_id = $employee_id";
$result = mysql_query($query);
echo $query;
if(!$result){
	echo 'Error in Search for Results:'.mysql_error();
	exit();
	}
	else{
		//Get Results
		global $last_name,$first_name,$email,$city,$street,$unit_no,$province,$country,$postal_code,$birth_date, $telephone,$oasis;
		$row = mysql_fetch_array($result);
		$last_name = $row['last_name'];
		$first_name = $row['first_name'];
		$email = $row['email'];
		$city = $row['city'];
		$street = $row['street'];
		$unit_no = $row['unit_no'];
		$province = $row['province'];
		$country = $row['country'];
		$postal_code = $row['postal_code'];
		$birth_date = $row['birth_date'];
		$telephone = $row['telephone'];
		$oasis = $row['oasis'];
	}
}

Thanks
TWB

bradgrafelman

Two things. They both deal with this bit of code:

if(!$result){ 
    echo 'Error in Search for Results:'.mysql_error(); 
    exit(); 
    }

Are you sure you want exit()? To stop processing the entire script? If you instead used return, i.e. 'return 0;' you could stop processing the rest of the function. I don't know how your script is set up, just a bit of info.

Secondly, are you saying that if no results are returned, this bit of code isn't stopping the function? Because if that's what you're saying, then you need to modify the code a bit. $result will only be FALSE if there was an error running the query. A query can run successfully even if no results are returned. Try this bit of code:

if(!$result || @mysql_num_rows($result) == 0){ 
    echo 'Error in Search for Results:'.mysql_error(); 
    exit(); 
    }

This probably isn't the best way (using the error surpressor), but it should still get the job done. Give it a try and let us know.

twb

bradgrafelman
The first timme the function runs it populates the field and echos the querry. However when I press the submit to update any changes it gives me the error..

Select * FROM employees WHERE employee_id = Error in Search for Results:

It gives me this error before it even gets to my update function.
Thanks
P.S. I ran your code with the same results.

Weedpacket

So there's something wonky about how you're calling the function then - you're not passing it the $employee_id if I read your transcription of the error message right.

Can we see the code that is calling it, and where it gets the employee id from?