[BNM] SQL hell

[delarge]

Yo all

This is starting to drive me loopy...

Can anyone see what is wrong with this sql statement?

$sql = "SELECT d.id, d.category, d.image1, d.image2, d.title, d.text,
d.phone, d.email, d.web, dc.cat_id, dc.category FROM directory d,
directory_categories dc WHERE dc.cat_id = $category ORDER by d.id LIMIT $eu,
$limit";


i get no errors, instead it selects everything - seems to be ignoring the
WHERE clause

$category is being passed via a query string and that's getting through
OK...

any ideas?

-- 
Paul Burgess

http://delarge.co.uk
http://streetstickers.co.uk
http://iampaulburgess.co.uk