Arrays, Variables and Database queries

[kreut]

Hello,

 

I've created a function whereby I want to return the school_id associated with a particular user.  Each user will be associated with exactly one school.  My query below works, but the thing that it returns is an array; I need to make use of it as a variable (say $instructor_school_id).  Any idea how to make the conversion from a single element array into a non-array variable?

 

Thank you....

 

function getInstructorSchool($read, $user_id) {
$sql = "SELECT school_id
		FROM users
		WHERE user_id = $user_id";
return $read->fetchRow($sql);
}

 

[cyberRobot]

I don't know what $read->fetchRow($sql); does, but you should be able to get a non-array variable by doing something like:

 

<?php
...
$school_id = myArray[0];
?>

 

or maybe:

 

<?php
...
$school_id = myArray['school_id'];
?>

[Ninjakreborn]

Echo out the contents of the variable that is returned from your function.

<?php
$variable = getInstructorSchool($read, $user_id);
echo '<pre>';
print_r($variable);
echo '</pre>';
?>

Do something like that, paste your output here, and I will tell you how to get it into a variable.