getting rows in particular week of the current month of the current year

[Vivid Lust]

Hi,

 

I'm wanting to find rows whose date is within the next week of the current month of the current year. The format of the date is, for example: 2010-10-28

 

Any ideas guys?

 

Thanks lots!

[Vivid Lust]

anyone?

[litebearer]

possible this may guide you

http://www.phpfreaks.com/forums/index.php?topic=311642.0

[Vivid Lust]

SELECT usuarioID, username, fechafin

FROM  `usr_usuarios`

WHERE DATE_FORMAT( fechafin,  '%y-%m-%d' )  BETWEEN DATE_FORMAT(

 

CURDATE( ) ,  '%y-%m-%d'

) AND DATE_FORMAT(

DATE_ADD(  CURDATE(

),  INTERVAL 35 DAY ) ,  '%y-%m-%d'

)

ORDER BY  `fechafin` ASC

LIMIT 10

MySQL ha dicho:

 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''%y-%m-%d')Â

BETWEEN DATE_FORMAT(CURDATE(), '%y-%m-%d')Â

ANDÂ DATE_FORMAT(' at line 3

[ignace]

SELECT usuarioID, username, fechafin FROM usr_usuarios WHERE week(fechafin) = week(now()) + 1