[ic] Customer Housekeeping & IC 4.8.7 - Resend
danb at championshipproductions.com
Fri Mar 4 11:08:35 EST 2005
>> This is untested...
>> SELECT userdb.username from userdb LEFT JOIN transactions ON
>> userdb.username=transactions.username WHERE transactions.code IS NULL
>> AND FROM_UNIXTIME(mod_time) < SUBDATE (NOW(), INTERVAL 1 MONTH);
> Hi Dan,
> Many thanks for the select :)
> Sadly it also fails in a similar way to the previous one and spews an
> error about (NOW(), INTERVAL 1 MONTH) which would indicate it doesn't
> like anything after < SUBDATE.
> I suspect the solution is to upgrade to a newer version of MySQL as
> clearly 3.23 is lacking in a fair bit of functionality.
> Once again, many thanks for your help :)
I use MySQL 3.23.58 and I pasted the query above into phpMyAdmin and it
ran fine. Do you have any more information about the error?
More information about the interchange-users