SQLSTATE[42S22]: Unknown column?

Question

[Lavrov95]

Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'math' in 'where clause' in C:\xampp\htdocs\forum\library\Forum.php:42 Stack trace: #0 C:\xampp\htdocs\forum\library\Forum.php(42): PDOStatement->execute() #1 C:\xampp\htdocs\forum\allquestions.php(26): Forum->getQuestion('18') #2 {main} thrown in C:\xampp\htdocs\forum\library\Forum.php on line 42



forum.php

<td><a href="allquestions.php?subject=math&id=<?php echo $userid; ?>">Math</a></td>

allquestions.php

$forum = new Forum();
$question = $forum->getQuestion($_GET['id']);

if (isset($question)) {
    foreach ($question as $key) { ?>
        <div class="question">
            <div>
 <?php
                echo $key['short_description'];
                ?>
 <div>
 <div>
<?php } ?>

Forum.php

public function getQuestion($question_id)
    {
        $subject = (string)$_GET['subject'];
        $sql = "SELECT * FROM forum WHERE subject=$subject";
        $query = $this->db->pdo->prepare($sql);
        $query->bindValue(':question_id', $question_id);
        $query->execute();
        $result = $query->fetchAll();
        return $result;
    }

Comments

[Алексей Скляров]

Вопросы какие-то подозрительные задаются. Вы читать не умеете? Написано же:

Column not found: 1054 Unknown column 'math' in 'where clause' in

. У вас нет колонки math.

[Lavrov95]

я хочу из forum взять subject и найти math , как это прописать

[Шамуэй]

SElect * from table where subject ='math';