[eluser]Phil Sturgeon[/eluser]
Quote:1.) Output the final query and see if it looks right. Do this after your model call or within the model after $this->db->get().
// Clear any existing output (optional)
ob_clean();
echo $this->db->last_query();
// Stop PHP from doing anything else (optional)
exit();
2.) If it looks fine, try running it in phpMyAdmin or another GUI.
3.) If it fails, you get an error message from MySQL server telling you what’s wrong. It will make it pretty obvious what change needs to be made to get it working.
4.) If it runs fine, then CodeIgniter is not running the query correctly. This could:
a.) CodeIgniter is logged into MySQL with a different user who may not have the same permissions.
b.) A condition is not being met in your model file or controller that is stopping the query from being run. Output values along the way.
Debugging ActiveRecord queries in CodeIgniter.
