Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Archived Discussions Archived Development & Programming Help with query structure, upcoming events and birthdays (two separate tables)
Help with query structure, upcoming events and birthdays (two separate tables)
  • El Forum
    Guest
  •  
#15
02-21-2010, 02:30 PM

[eluser]omick[/eluser]
hmmm... sorry... did you copy and paste the code? maybe some smart quotes problem... i should have place it in a code block...

Code:
AND DATE_FORMAT(birth_date, '%m%d')  BETWEEN DATE_FORMAT(NOW(), '%m%d') AND DATE_FORMAT(DATE_ADD(NOW(), INTERVAL 1 WEEK), '%m%d')


Messages In This Thread
Help with query structure, upcoming events and birthdays (two separate tables) - by El Forum - 02-21-2010, 02:30 PM



Theme © iAndrew 2016 - Forum software by © MyBB