implode query

[Reece Jones]

$fixtures = array();

$fixtures = mysqli_query($db_connect, "SELECT `fixtureid` FROM `myfixtures` WHERE `id`='".$_SESSION['usr_id']."'"); 

$new = array();

//$all = mysqli_fetch_assoc($fixtures);

while(($row = mysqli_fetch_array($fixtures))) {

   $new[] = $row;

}

$all = array_column($new, 'fixtureid');

var_dump($all);

 $result = mysqli_query($db_connect, "SELECT * FROM `fixtures` WHERE `fixtureid` (" . implode(",",$all) . ")");

Hi, wondering if anybody could help, the vardump shows..

array (size=3)
  0 => string '11' (length=2)
  1 => string '11' (length=2)
  2 => string '63' (length=2)

The $result query is returning false and im not sure why, ive tried everything, 

thanks.

[ved]

 $result = mysqli_query($db_connect, "SELECT * FROM `fixtures` WHERE `fixtureid` (" . implode(",",$all) . ")");

I think you're missing an IN() statement. Should probably be "WHERE fixtureid IN(val1,val2)" 

[ikkez]

you missded the IN statement:  "WHERE `fixtureid` IN ("

[Reece Jones]

thanks!

[Reece Jones]

thanks!