Passing key issue - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5) +--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24) +--- Thread: Passing key issue (/showthread.php?tid=74841) |
Passing key issue - manigopal - 11-14-2019 I am trying to pass a value and display datas based on it. Like Passing a Genre Type and filtering movies based on that Genre alone. The error which i get is A Database Error Occurred Error Number: 1054 Unknown column 'Action' in 'where clause' SELECT * FROM `movies_info` WHERE find_in_set(Action,genre_info) > 0 LIMIT 24 Filename: C:/xampp/htdocs/ciprojects/showtime/system/database/DB_driver.php Line Number: 691 Files at, Model file @ https://gitlab.com/manigopal/ci-projects/blob/master/Showtime/Model_movie_genre.php Controller @ https://gitlab.com/manigopal/ci-projects/blob/master/Showtime/Movies_genre.php View @ https://gitlab.com/manigopal/ci-projects/blob/master/Showtime/view_movies_genre.php SQL @ https://gitlab.com/manigopal/ci-projects/blob/master/Showtime/ci_showtime.sql Reference code i have used from, https://gitlab.com/manigopal/ci-projects/tree/master/Showtime/Referenced%20Codes Live at http:// cishowtime(dot)22web(dot)org/movies/genre/Action RE: Passing key issue - muuucho - 11-14-2019 Have you checked that you have a column 'Action' in table 'movies_info' ? RE: Passing key issue - manigopal - 11-14-2019 (11-14-2019, 04:14 AM)muuucho Wrote: Have you checked that you have a column 'Action' in table 'movies_info' ? i have modified / updated my code (same link) now no error shows but no values are getting returned., even there are movies i get as No Movie Found by Animation @ http://cishowtime (dot) 22web (dot) org/movies/genre/Animation RE: Passing key issue - manigopal - 11-14-2019 i have made some modifications to the code, which is not showing any error but it response with null value., i took a code from net and they have used genre_id to get stored in videos table, in my case i wanted to store genre_type(which is genre name itself like animation,action) i tried changing some values but it doesnt worked out., RE: Passing key issue - muuucho - 11-16-2019 I still can't see the column 'Action' in table 'movies_info' |