title: SET time_zone = '+05:30' is not working PHP
body: <p>I have following query which works fine for me on my localhost and sets current time in database.</p>
  
  <pre><code>$query="INSERT INTO mytable (user_id, user_datetime) VALUES ".
         "(".$_SESSION["user_id"].", NOW());";
  </code></pre>
  
  <p>But when I hosted my website on a US server, it is putting US current time in database, which is undesirable. I want to put Indian current time.</p>
  
  <p>For that I am modifying above query as</p>
  
  <pre><code>$query="SET time_zone = '+05:30';INSERT INTO mytable (user_id, user_datetime) VALUES ".
         "(".$_SESSION["user_id"].", NOW());";
  </code></pre>
  
  <p>But this is not working. Although if I run <code>SET time_zone = '+05:30';</code> on mysql directly, it works? Where I should look to resolve it?</p>