PHP Mysqli select two DISTINCT from data base
<p>I am trying to fetch two different DISTINCT values from data base am not able to do that that gives me an error. I don't want both to be combined in as statement and fetch as one I need individual DISTINCT values.</p>

<blockquote>
  <p>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT AttendanceID from attendance_master where Attendence_taken_by !='admi' at line 1\</p>
</blockquote>

<p>My Query</p>

<pre><code>$query = "select DISTINCT Standard , DISTINCT AttendanceID  from attendance_master where  Attendence_taken_by !='$admin'  and  SchoolID='$schoolid' and AttendanceDate &gt;= '$tfrom_date' and AttendanceDate &lt;= '$tto_date' ";

$result = mysqli_query($mysqli,$query)or die(mysqli_error($mysqli));
while($row=mysqli_fetch_array($result))
{
    echo "&lt;table&gt;&lt;tr&gt;".$row["Standard"]."&lt;/tr&gt;&lt;tr&gt;".$row["AttendanceID"]."&lt;/tr&gt;&lt;/table&gt;";
}
</code></pre>