in reply to Oddly named Mysql table and backticks

looks like the SELECT statement you posted is missing a ')'
should be:

SELECT trnemailaddress, activedate FROM `customer-trans` WHERE (UNIX_T
+IMESTAMP(activedate) + ? ) < (UNIX_TIMESTAMP(NOW()));

[download]

Replies are listed 'Best First'.
Re^2: Oddly named Mysql table and backticks
by neilwatson (Priest) on Jun 18, 2005 at 15:00 UTC
    It was the extra backet. Thanks for setting me straight.

    Neil Watson
    watson-wilson.ca

[reply]
      no problem, an extra set of eyes always helps
      -Eric
[reply]

In Section Seekers of Perl Wisdom