• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Passing key issue

#1
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..._genre.php
Controller @ https://gitlab.com/manigopal/ci-projects..._genre.php
View @ https://gitlab.com/manigopal/ci-projects..._genre.php
SQL @ https://gitlab.com/manigopal/ci-projects...owtime.sql

Reference code i have used from,
https://gitlab.com/manigopal/ci-projects...ed%20Codes

Live at http:// cishowtime(dot)22web(dot)org/movies/genre/Action
Reply

#2
Have you checked that you have a column 'Action' in table 'movies_info' ?
Reply

#3
(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

Reply

#4
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.,
Reply

#5
I still can't see the column 'Action' in table 'movies_info'
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.