Getting two different Day values from Date()
<p>So I have a database full of daily events that I want to show on a php page. I've connected to the database &amp; populated the table - no problems. I then created a list of links that show the days of the week, so that the user can click on the day and the table will be populated by whatever event is scheduled for that day:</p>

<pre><code>&lt;ul id="day-list"&gt;
    &lt;li&gt;&lt;a href="?eventDay=Monday"&gt;Monday&lt;/a&gt;&lt;/li&gt;
    &lt;li&gt;&lt;a href="?eventDay=Tuesday"&gt;Tuesday&lt;/a&gt;&lt;/li&gt;
    ...etc etc... you get the idea.
&lt;/ul&gt;
</code></pre>

<p>In the code prior to setting up the day list, I have this:</p>

<pre><code>$theDay = isset($_GET['eventDay']) ? $_GET['eventDay'] : date('l', time())
// I've also tried date('l');
$data = $conn-&gt;query("SELECT * FROM 'my_table' WHERE 'event_day' = '$theDay';");
</code></pre>

<p>This is supposed to choose either whatever day the user selected, or today's day if $_GET['meetingDay'] is null/nil. It does actually works, however, I've notice about 9pm (my time) it switches over to the next day. I've also written <em>date('l')</em> and <em>date('l', time())</em> on the same page elsewhere and THAT displays the correct time, I just have this issue with $theDay variable.</p>

<p>I've looked into mysql &amp; php timezones, and anything I research yielded me no results on my page (things like mysql's 'set time_zone' and php's 'date_default_timezone_set'). Does anyone know what's going on here?</p>
