On Sunday 04 February 2007 17:24:29 Jim MacDiarmid wrote: > I've been trying to figure this out using the CURDATE() function, but I > keep getting a syntax error. Below is the code I'm using: > > SELECT > `vb_links`.`DateAdded` > FROM > `vb_links` > WHERE DATEDIFF( CURDATE() , `vb_links`.`DateAdded` );
Normally, a WHERE condition says WHERE field = [constant|function()|...] You have WHERE function(). -- Scanned by iCritical. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]