Database selection error / Parse Error: Syntax Error

Question

Parse error: syntax error, unexpected '$result' (T_VARIABLE) in C:\xampp\htdocs\quiz\serverDB.php on line 159

I can't figure out what's wrong >_<

<?php
            $fetch="SELECT questions.question_id, questions.question, answers.answer
                    FROM questions
                    WHERE isActive=1
                    INNER JOIN answers
                    ON questions.question_id=answers.question_id ORDER BY questions.question_id;"
            $result = mysql_query($fetch, $connection);
            if(!$result){
                die( "Database selection failed: " . mysql_error());
                }
                while($row = mysql_fetch_array($result)){
                    echo "<form method=\"post\" action=\"editQuestions.php\">";
                    echo "<tr>";
                    echo "<input type=\"hidden\" name=\"index\" value=\"".$row['question_id']."\">";
                        for($ctrCell=1;$ctrCell<=6;$ctrCell++){
                        echo "<td>";
                        echo $row[$ctrCell];
                        echo "</td>";
                        }
                        echo "<td style=\"border-left: solid 1px #00478F;\" class=\"action\"><input type=\"submit\" name=\"btnAction\" value=\"EDIT\"></td>";
                        echo "<td style=\"border-right: solid 1px #00478F;\" class=\"action\"><input type=\"submit\" name=\"btnAction\" value=\"DELETE\"></td>";
                    echo "</tr>";
                    echo "</form>";
                }
?>

score 1 · Answer 1 · answered Dec 09 '15 at 04:48

1

You have missed / misplaced a semi-colon in $fetch:

$fetch="SELECT questions.question_id, questions.question, answers.answer
                    FROM questions
                    WHERE isActive=1
                    INNER JOIN answers
                    ON questions.question_id=answers.question_id ORDER BY questions.question_id;";
                                                                                               ^ ^

answered Dec 09 '15 at 04:48

Thamilhan

13,040
5
37
59

Oh, thank you!! I can now proceed to solving the next problem...hahaha!! ^_^ didn't notice the misplaced semi colon -_- – korzero Dec 09 '15 at 04:52
1

@korzero Can you pls accept the answer, if it resolves your problem? – Tᴀʀᴇǫ Mᴀʜᴍᴏᴏᴅ Dec 09 '15 at 04:53

score 0 · Answer 2 · answered Dec 09 '15 at 04:53

$fetch="SELECT questions.question_id, questions.question, answers.answer FROM questions WHERE isActive=1 INNER JOIN answers ON questions.question_id=answers.question_id ORDER BY questions.question_id";

Database selection error / Parse Error: Syntax Error

2 Answers2