[BNM] SQL hell

[Alan Newman]

>>> FROM directory d,
directory_categories dc

The FROM clause looks suspect to me - but then again I am not sure what
flavor of SQL this is.

why is there a space before "d" and  "dc"?

- Alan


-----Original Message-----
From: delarge [mailto:delargerock at gmail.com]
Sent: 04 July 2006 15:48
To: Brighton New Media
Subject: [BNM] SQL hell


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
--

BNM info/subscription/archives: http://www.brightonnewmedia.org/

BNM archive search: http://www.roddis.org/bnm/search.php
BNM Del.icio.us tag: http://del.icio.us/tag/bnm/
BNM Flickr group: http://www.flickr.com/groups/bnm/

BNM powered by http://www.screen-play.net/