calling from url

[wazo]

Hi guys

Im trying to list all jobs in the database via category that has been passed in the url

sector.php?category=Construction

$category = $_GET["category"];

$sql = ("select * from   jobs where category = $category"); 

can anyone see my error?

[hexburner]

Put the variable between single quotes:

$query = ("select * from jobs where category = '$category'");