[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