Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Archived Discussions Archived Development & Programming How to get entries from DB depending on timezone?
How to get entries from DB depending on timezone?
  • El Forum
    Guest
  •  
#6
04-12-2010, 02:53 PM

[eluser]danmontgomery[/eluser]
You have the user's GMT offset, and the GMT offset for each show time... What's the dilemma?

Code:
SELECT * FROM my_table WHERE timezone = 'GMT+5'


Messages In This Thread
How to get entries from DB depending on timezone? - by El Forum - 04-10-2010, 06:35 AM
How to get entries from DB depending on timezone? - by El Forum - 04-10-2010, 07:26 AM
How to get entries from DB depending on timezone? - by El Forum - 04-10-2010, 11:01 AM
How to get entries from DB depending on timezone? - by El Forum - 04-12-2010, 12:24 PM
How to get entries from DB depending on timezone? - by El Forum - 04-12-2010, 02:49 PM
How to get entries from DB depending on timezone? - by El Forum - 04-12-2010, 02:53 PM
How to get entries from DB depending on timezone? - by El Forum - 04-12-2010, 02:58 PM
How to get entries from DB depending on timezone? - by El Forum - 04-12-2010, 03:28 PM
How to get entries from DB depending on timezone? - by El Forum - 04-12-2010, 03:53 PM
How to get entries from DB depending on timezone? - by El Forum - 04-12-2010, 04:12 PM
How to get entries from DB depending on timezone? - by El Forum - 04-15-2010, 10:20 AM
How to get entries from DB depending on timezone? - by El Forum - 04-15-2010, 11:39 AM
How to get entries from DB depending on timezone? - by El Forum - 04-15-2010, 11:41 AM



Theme © iAndrew 2016 - Forum software by © MyBB