Issue with joining tables. |
08-24-2018, 03:11 PM
(This post was last modified: 08-24-2018, 03:13 PM by HarrysR. Edit Reason: Added the 404 issue too.. )
Hey guys,
I know it might be a silly question but i can't make it work and it drives me crazy. I have a view.php for displaying single item details. In model file i'm trying to join some tables (in which some columns are INT and have 0 value). When I'm trying to get a single entry where the INT column is 0, i can't get any info shown in the "view.php" file (if i also place the show_404 if data are empty i get redirected. Which means that it does not get any data). When i erase the db join it works fine. My guess is something i made wrong with the db or the model. Any ideas?! Controller Code: public function view($pet_entry_id = NULL, $pet_entry_slug = NULL){ Model file Code: public function get_pets($pet_entry_id = 0, $pet_entry_slug = FALSE){ Thank you in advance! //Life motto if (sad() == true) { sad().stop(); develop(); } |
Messages In This Thread |
Issue with joining tables. - by HarrysR - 08-24-2018, 03:11 PM
RE: Issue with joining tables. - by jreklund - 08-25-2018, 05:31 AM
RE: Issue with joining tables. - by HarrysR - 08-25-2018, 12:33 PM
RE: Issue with joining tables. - by HarrysR - 08-25-2018, 02:15 PM
|