[Resolved] Search command error

[HalfLife]

Here is the code:

$job = $_GET['query'];
$result = mysql_query("SELECT * FROM team WHERE occupation LIKE '%$job%' ORDER BY id DESC");
$total = mysql_numrows($result);
print ($total);

I have several cells with matching search term ($job), but $total always returns 0 for some reason...

[tomwerner]

try putting {$job} insted of $job, I think this is similar to a problem I had about 6 months ago, it was trying to use the string $var instead of the contents of $var.

[HalfLife]

Thanks but I found out what the problem was...
Query said Pencillers while database stored Penciller... Damn plural 's'...