CodingForums.com - View Single Post

mharrison · 12-12-2012, 06:45 PM

Figured it out...had my ()'s wrong.

Correctly works with

Code:

$result = mysql_query("SELECT * FROM patterns WHERE YEARWEEK(datetxt) = YEARWEEK(CURDATE()) ORDER BY dsptxt");

12-12-2012, 06:45 PM	PM User \| #3
mharrison New Coder Join Date: Dec 2012 Posts: 52 Thanks: 12 Thanked 0 Times in 0 Posts	Figured it out...had my ()'s wrong. Correctly works with Code: $result = mysql_query("SELECT * FROM patterns WHERE YEARWEEK(datetxt) = YEARWEEK(CURDATE()) ORDER BY dsptxt");