php mysql IN search rows

Question

I have the following code

$sql="select * from movieTrivia WHERE id IN ('9,2,1,4,7')";
$array = array();
if ($result = $mysqli->query($sql)) {
    // If the query was sucsessfull, we can get the rows
    while ($row= $result->fetch_array()) {
    $array[] = $row;

}
} else {
    // If the query failed, do something here
}
   $a               = $row['title']; 
    $b                  = $row[1]['title'];  //out put second id in array (2)?
    $c                  = $row['title']; 
    $d                  = $row['title']; 
echo json_encode(array("a" => $a, "b" => $b, "c" => $c, "d" => $d, "answerImg" => $answerImg));

Out Put is: $a = title1 $b = null $c = title1 $d = title1

It only pulls the title from the first ID in the IN array (9). How do i pull the title of 2, 1, 4 and 7

try with $sql="select * from movieTrivia WHERE id IN (9,2,1,4,7)"; — Hardy Mathew
– Hardy Mathew, Commented Nov 16, 2015 at 20:04
Your fetch is not returning a multidimensional array. $a, ,$c, and $d will all have the same values. You overwrite on every iteration. — chris85
– chris85, Commented Nov 16, 2015 at 20:06
OKay, as i suspected, how do i put the data from (9,2,1,4,7) into an array I can access as i can above? — Joe Bragist
– Joe Bragist, Commented Nov 17, 2015 at 0:03

Lucky Chingi · Accepted Answer · 2015-11-16 20:05:14Z

1

you dont need quotes inside the IN brackets

$sql="select * from movieTrivia WHERE `id` IN (9,2,1,4,7)";

answered Nov 16, 2015 at 20:05

Lucky Chingi

2,2561 gold badge13 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Joe Bragist Over a year ago

Thanks, i made the change

Collectives™ on Stack Overflow

php mysql IN search rows

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related