mysql - Search database using array and then echo/print result in foreach loop using PHP -

i need variable code url $codes = $_get['code']; (url example website.com/update?code[]=7291&code[]=9274&code[]=8264&) select firstname guests invitecode = $codes" output data , set $relatives = $row["firstname"] , later on in file need echo/print print $relative.

why not working me?

... connection made ... $codes = $_get['code']; $sql = "select firstname guests invitecode = $codes"; $result = mysqli_query($conn, $sql); if (mysqli_num_rows($result) > 0) { // output data of each row while($row = mysqli_fetch_assoc($result)) {     $relatives[] = $row["firstname"]; } }  foreach ($relatives $relative) { print $relative; } 

update:

so using:

<?php  $codes = $_get['code']; $thecodes = ""; foreach($codes $vals)     $thecodes .= (int)$vals . ","; if($thecodes != "") {     $thecodes = trim($thecodes, ",");     $sql = "select firstname guests invitecode in ($thecodes)";     $result = mysqli_query($conn, $sql); $result = mysqli_query($conn, $sql); if (mysqli_num_rows($result) > 0) { while($row = mysqli_fetch_assoc($result)) {     $relatives[] = $row["firstname"]; } } foreach ($relatives $relative) { print $relative; } } else { }  ?> 

it works enter foreach ($relatives $relative) { echo $relative; }; value $message = $firstname . " " . $lastname . " coming event. " . ;.

in end turn out this: $message = $firstname . " " . $lastname . " coming event. " . foreach ($relatives $relative) { echo $relative . " "; };.

for reason won't work when combine them.

use in operator this.

<?php  $codes = $_get['code']; $thecodes = ""; foreach($codes $vals)     $thecodes .= (int)$vals . ","; //loop through making sure each int security reasons (no sqli) if($thecodes != "") //there @ least 1 code {     $thecodes = trim($thecodes, ","); //remove additional commas     $sql = "select firstname, lastname guests invitecode in ($thecodes)"; //use in operator     $result = mysqli_query($conn, $sql);     if (mysqli_num_rows($result) > 0) {         while($row = mysqli_fetch_assoc($result)) {             echo $row["firstname"] . " " . $row["lastname"] . "is coming event";         }     }  } else //no codes queried {  }  ?>