CodingForums.com - View Single Post

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

I've also tried it this way:

Code:

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

It doesn't error out, but doesn't display any results either and I have a test db it's connecting to where I have put 3 records in with the date being todays date.

12-12-2012, 06:41 PM	PM User \| #2
mharrison New Coder Join Date: Dec 2012 Posts: 52 Thanks: 12 Thanked 0 Times in 0 Posts	I've also tried it this way: Code: $result = mysql_query("SELECT * FROM patterns WHERE YEARWEEK(datetxt = YEARWEEK(CURDATE())) ORDER BY dsptxt"); It doesn't error out, but doesn't display any results either and I have a test db it's connecting to where I have put 3 records in with the date being todays date.