So I am trying to call a stored function within my SELECT statement using mysql_query in PHP. For some reason it does not return a valid result resource.
Example: (assuming connection is already made)
$query = "SELECT DetermineTestCategoryPath(17)";
$result = mysql_query($query, $this->con);
I get the error:
'mysql_query(): Unable to save result set'
From what I read you should be able to call a stored function directly in the SELECT statement like you normally would with mysql_query(), but for some reason it doesn't work. I have tested the query in MySQL Query Browser and it works perfectly.
Any ideas?
