Notice: Use of undefined constant
_LINE_- assumed_LINE_in C:\xampp\htdocs\quizzer\question.php on line 9
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''questions' WHERE question_number = 1' at line 1_LINE_
Asked
Active
Viewed 33 times
-1
Funk Forty Niner
- 74,450
- 15
- 68
- 141
-
can anyone help me out? – Titus Opem Oct 01 '17 at 13:38
-
1Not without you showing your actual code. – Jonathon Reinhart Oct 01 '17 at 13:40
-
2PHP line's constant is `__LINE__` note the two underscores before and after – Raymond Nijland Oct 01 '17 at 13:42
-
These are actually two errors: you have answers for the `use of undefined constant _LINE_` notice. To help you solve the `error in your SQL syntax` error, we need to see the rest of your query. – rickdenhaan Oct 01 '17 at 13:52
-
query($query) or die($mysqli->error_LINE_); $question = $result->fetch_assoc(); ?> – Titus Opem Oct 01 '17 at 13:57
-
To fix your SQL error, table and column names in MySQL should be wrapped in backticks instead of single quotes. Although "questions" isn't a reserved word in MySQL, so wrapping it is optional. – rickdenhaan Oct 01 '17 at 14:04
-
thanks guys, is working now after i had removed the quotes on the 'question'. – Titus Opem Oct 01 '17 at 14:24
-
am getting another error in my code: – Titus Opem Oct 01 '17 at 15:18
-
this is the actual error is given me fetch_assoc()) : ?> – Titus Opem Oct 01 '17 at 15:21
1 Answers
2
You are using the PHP Magic constants incorrectly. It should be __LINE__, 2 underscores preceded and followed.
gk.
- 338
- 5
- 15