การ SELECT ข้อมูล โดยใช้ ตัวแปร Array สามารถเรียกออกมาได้ เเต่ว่าข้อมูลมันซ้ำกัน

<?php
$hdata = array("R", "I", "A", "S", "E", "C");
$data=array($_SESSION['answer']['R'],$_SESSION['answer']['I'],$_SESSION['answer']['A'],$_SESSION['answer']['S'],$_SESSION['answer']['E'],$_SESSION['answer']['C'])
?>

$conn = new mysqli($serverName,$userName,$userPassword,$dbName);


  $Attribute = implode("', '", $hdata);
  $Parameter = implode("', '", $data);
  
  $sql = "SELECT * FROM Project Where Attribute in ('$Attribute') and Parameter in ('$Parameter')";

  $query = $conn->query($sql);
  //$query->num_rows;

  while($result = $query->fetch_assoc())
  {
    echo $result["Attribute"]."&nbsp";
    echo $result["Parameter"]."&nbsp";
    echo $result["Information"]."&nbsp";
    echo $result["Graphic"]."&nbsp";
    echo $result["Commutication"]."&nbsp";
    echo $result["Program"]."&nbsp";
    echo $result["ICT"]."&nbsp";
    echo $result["Databaseadmin"]."&nbsp";
    echo "<br>";
  }
  
  $conn->close();

$w = '';
foreach($_SESSION['answer'] as $key=>$value){
    $w .= ($w>''? ' or ' : '')."( attribute='$key' and parameter='$value') ";
}
$sql = 'SELECT * FROM Project where '.$w;

$sql = 'SELECT * FROM Project where '.$w;

SELECT ...... SUM(score) as s_score FROM ... GROUP BY ID or score