I figured out that I can create new canned searches by modifying canned_searches.php. I'd like to search for movies on HBO channels only. I'm at a loss on how to do perform a search only on specific channels. I searched the forums and did not see anything on creating customized searches. Can someone either give me a hint or let me know where else to look? Is the database structure documented somewhere?

Thanks.

_________________
MSI K7N2GM2-LSR (Integrated Video)
Athlon XP 2800+
512M RAM
160GB WD
Hauppauge PVR-150

I messed around some more and I can accomplish what I want by doing the following:

=> "category_type'".movie_word."' AND program.channid LIKE '1310' OR program.chanid LIKE '1311' OR program.chanid LIKE ...

I can just put a bunch of OR values in and accomplish what I want, but is there a better way?

Thanks.

_________________
MSI K7N2GM2-LSR (Integrated Video)
Athlon XP 2800+
512M RAM
160GB WD
Hauppauge PVR-150

First, you typically want to avoid "LIKE" searches unless you're dealing with certain types of fields as they don't perform as well.

Try changing to:



Take out the etc... of course and replace with as many values as necessary.

It's easier to manage.

Thanks for the information. It's a much cleaner way to do what I wanted. I did need to put tick marks around each channel to make it work properly.

_________________
MSI K7N2GM2-LSR (Integrated Video)
Athlon XP 2800+
512M RAM
160GB WD
Hauppauge PVR-150