Help Required! Stored Procedures and MySQL Functions in CI.

[eluser]TheFuzzy0ne[/eluser]
Are you sure your stored procedure is working correctly?

You can enable the [url="http://ellislab.com/codeigniter/user-guide/general/profiling.html"]profiler[/url] with:

Code:

$this->output->enable_profiler(TRUE); // Either at the top of your controller method, or in your constructor.

and that will show you what queries are being made.