Adding a WHERE clause but it still results in error

Question

The question states that I should "Add a WHERE clause to accept only the member that matches the passed member_id". And that's what I've done, but I still receive "Bummer! Use a WHERE statement to limit the results to a single member_id."

index.php

<?php
function get_member( $id ) {
    include("connection.php");

    try {
      $results = $db->query(
          "SELECT member_id, email, fullname, level
          FROM members
          WHERE member_id = $id
          "
      );
    } catch (Exception $e) {
      echo "bad query";
    }

    $members = $results->fetch();
    return $members;
}

Answer 1 · 2016-09-03T15:51:28Z

September 3, 2016 3:51pm

Hey Victoria,

Your code is correct. The problem lies in that you modified some of the code that you shouldn't have between Task 1 and Task 2.

The line

$members = $results->fetch();

Originally was

$members = $results->fetchAll();

Change this line back to what it was and your code will pass.

Keep Coding! :)

Answer 2 · 2016-09-03T15:41:44Z

September 3, 2016 3:41pm

H Victoria the problem that you not pass the correct variable please see the comment blow

<?php
function get_member($member_id) {
    include("connection.php");

    try {
      $results = $db->query(
          "SELECT member_id, email, fullname, level
          FROM members WHERE member_id = $member_id " // here the mistake ...
      );
    } catch (Exception $e) {
      echo "bad query";
    }

    $members = $results->fetchAll();
    return $members;
}

Answer 3 · 2016-09-03T15:42:22Z

September 3, 2016 3:42pm

please if you pass this challenge give me the code : https://teamtreehouse.com/library/integrating-php-with-databases/using-relational-tables/joining-tables

Answer 4 · 2016-09-03T15:54:26Z

September 3, 2016 3:54pm

By the way, here's the answer for the other challenge:

SELECT * FROM Media 
JOIN Media_Genres ON Media.media_id = Media_Genres.media_id
JOIN Genres ON Media_Genres.genre_id = Genres.genre_id
WHERE Media.media_id=3;

You need to Join media to Genres, but tehre's no direct connection between them, so you need to joing Media to Media_Genres first, and then, Media_Genres to Genres. Also, you need to use Media.media_id=3 instead of media_id=3 because SQL won't know which of the "media_id" fields you are referring to.

Welcome to the Treehouse Community

Looking to learn something new?

Victoria Loisi

Victoria Loisi

Adding a WHERE clause but it still results in error

4 Answers

Jason Anders

Jason Anders

Hazem mosaad

Hazem mosaad

Jason Anders

Jason Anders

Hazem mosaad

Hazem mosaad

Victoria Loisi

Victoria Loisi