数据库查询无法按预期运行

Question

Hi i'm using a query to extract data from the table, from a dynamic link. and ummm the code I've used SEEMS to be okay, yet i get a 'Database Query Failed' can someone tell me why?

here's the code:

<?php
$PIN = $_GET['Pin'];

$query="SELECT * FROM Accident_Investigation WHERE PIN = $PIN";
$result = mysqli_query($connection, $query);

if(!$result){
    die("Database query failed.");
    } 
?>

Answer 1

Change $PIN to '$PIN' in SQL statement provided everything else works fine.