[mythtv-users] Custom MythWeb search (MySQL/php) assistance required

Chris Petersen lists at forevermore.net
Sat Jul 8 07:45:57 UTC 2006


> I add this into MythWeb canned_searches.php :
> 
>      ('Movies (maybe)')
>         => 'set @timef00;'

you can't string queries together like that.

>           .'(UNIX_TIMESTAMP(endtime) - UNIX_TIMESTAMP(starttime)) >>           .'AND (category >           .'OR category >           .'OR category >           .'OR category >           .'OR category >           .'OR category >           .'OR category > 
> The query fails at "'set @timef00;(UNIX_TIMESTAMP(endtime)...".
>
> Does anybody know how to do the same query without using the @variable
> or the correct syntax to use in canned_searches.php ?

yeah, how about just use ">

-Chris

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 251 bytes
Desc: OpenPGP digital signature
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20060708/0d6d1dd4/attachment.pgp 


More information about the mythtv-users mailing list