title: PHP syntax error in SELECT mySQL query
body: <p>I am trying to execute this mySQL query in PHP.</p>
  
  <pre><code>$sql = "SELECT * FROM Property 
          WHERE CONCAT(name, '',
                       contact_number , '', 
                       hostel_address,'',
                       renter_name,'',
                       other_details,'',
                       date_posted,'') LIKE '%".$var."'
          ORDER BY STR_TO_DATE(date_posted,'%d/%m/%Y')";
  </code></pre>
  
  <p><strong>An I am getting following error:</strong> </p>
  
  <blockquote>
    <p>You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY STR_TO_DATE(date_posted,'%d/%m/%Y') ASC' at line 1 </p>
  </blockquote>
  
  <p>Any help here :(</p>