Author Topic: Featured Movie / Recommended Movie  (Read 8703 times)

0 Members and 3 Guests are viewing this topic.

bp_pbs

  • Contributor
  • ***
  • Posts: 94
  • Karma: 1
    • View Profile
Re: Featured Movie / Recommended Movie
« Reply #30 on: May 31, 2012, 06:40:19 AM »
you should be able to add to the existing query
"and c05 > 6"
c05 being Rating and 6 being the rating of the movie. The rating should go from 1-10

queryvideodatabase(select c00,c01 from movie where c14 LIKE '{1}%%' or c14 LIKE '%% {1}%%' and c05 > 6 order by random() Limit 1)

thesystemera

  • $upporter
  • Sr. Member
  • *****
  • Posts: 125
  • Karma: 0
    • View Profile
Re: Featured Movie / Recommended Movie
« Reply #31 on: June 01, 2012, 10:35:56 PM »
Brilliant.  Thanks for that..  Will give it a try...

thesystemera

  • $upporter
  • Sr. Member
  • *****
  • Posts: 125
  • Karma: 0
    • View Profile
Re: Featured Movie / Recommended Movie
« Reply #32 on: June 02, 2012, 05:37:29 AM »
This works great now, got it only recommending good films...  Returns back the correct page almost all the time...  Good stuff guys...  Will be sharing my natural language config in the coming week..