Help Required! Stored Procedures and MySQL Functions in CI.

[eluser]Falney[/eluser]
There are no errors popping up. Even if I populate the variables as constants, i.e. an actual username that I know for a fact exists, the query comes back with no results in any way shape or form.

If I go

Code:

$query = $this->db->query(“call acquireuserpasswd(’$uname’, @id,@passwd);”);
$return = $this->db->query("SELECT @passwd");
foreach($return->result() as $row){
   $password = $row->passwd;
}

Nothing happens.

if I try debugging with

Code:

echo $return;
echo "testline<br>";
print_r($return, TRUE);

it comes up with an understandable error about the $return object but the print_r() function yields no text.

I am at a loss as to what I need to do. I really wish I could just do in with the stored procedure but it really is not an option.