title: sending query from Android to php
body: <p>I wrote a php file on Raspberry pi, using "$_Get" to receive query query strings including date('Y-m-d').
  But I keep getting syntax error and I can't find out which part is wrong....</p>
  
  <p>Here's my php code below:</p>
  
  <pre><code>{
      $connect = mysqli_connect("220.133.21.50", "root", "120232", "weather");
      $query = 'SELECT * FROM dosensor ORDER BY num ASC';
      $result = mysqli_query($connect, $query);
  
      $s="";
      while($row = mysqli_fetch_assoc($result))
          {$result = mysqli_query($connect, "Select * FROM dosensor ORDER BY num ASC WHERE `recordtime` 
            &lt;='".$_GET["date('Y-m-d')"]."';");
            if ($s=="")  $s=$s."['".$row["recordtime"]."',".$row["DO"]."]";
            else $s=$s.",['".$row["recordtime"]."',".$row["DO"]."]";
          }
      }
  </code></pre>
  
  <p>And here's the query string sending from my Android Studio:</p>
  
  <pre><code>webview.loadUrl("http://"+intent.getStringExtra("ip")+":/linechart.php? 
  </code></pre>
  
  <p>uid="+intent.getStringExtra("uid")+"&amp;pw="+intent.getStringExtra("password")+"&amp;date('Y-m-d') 
      AND recordtime >= date('Y-m-d',strtotime('-10 day'))");</p>
  
  <p>Could someone tell my which part is causing syntax error?
  the error should be on this line</p>
  
  <pre><code>$result = mysqli_query($connect, "Select * FROM dosensor ORDER BY num ASC WHERE `recordtime` 
  &lt;='".$_GET["date('Y-m-d')"]."';");
  </code></pre>