easy query, what's wrong with it?

[Guest]

tep_db_query("select customers_info_date_account_created, customers_info_date_of_last_logon, customers_info_id from customers_info where customers_info_date_of_last_logon = 'NULL' and to_days(now()) - to_days(customers_info_date_account_created) >= 120 order by customers_info_id asc limit 0,1");

 

trying to output the 1st record in which the customer either HAS NOT logged in or has REGISTERED more than 120 days ago, but it doesn't seem to be outputting anything.

[bill110]

Try this: (the table needs to be defined in caps and with " . TABLE_NAME ." not sure if anything else is wrong)

tep_db_query("select customers_info_date_account_created, customers_info_date_of_last_logon, customers_info_id from" . TABLE_CUSTOMERS_INFO . " where customers_info_date_of_last_logon = 'NULL' and to_days(now()) - to_days(customers_info_date_account_created) >= 120 order by customers_info_id asc limit 0,1");