Hello gurus,
Please help. Where is my mistake?
I get the following error...
MYSQL: query failed: You have an error in your SQL syntax near ') < rei_ts' at line 1
When I run the query below ....
SELECT rei_ip \
FROM relay_ip \
WHERE rei_ip="${sender_host_address}" AND DATE_SUB(NOW(), INTERVAL 10) < rei_ts
And the tabledesign is ...
CREATE TABLE relay_ip (
rei_aid int(11) NOT NULL auto_increment,
rei_uname varchar(30) NOT NULL default '',
rei_domain varchar(128) NOT NULL default '',
rei_ip varchar(64) NOT NULL default '',
rei_ts datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (rei_aid),
KEY rei_ip (rei_ip)
) ;
-Wash
--
Odhiambo Washington <[EMAIL PROTECTED]> "The box said 'Requires
Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,'
Tel: +254 2 313985-9 +254 2 313922 so I installed FreeBSD."
GSM: +254 72 743223 +254 733 744121 This sig is McQ! :-)
"If the King's English was good enough for Jesus, it's good enough for
me!"
-- "Ma" Ferguson, Governor of Texas (circa 1920)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
