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]

Reply via email to