[BNM] SQL hell

[Ali]

hi paul

maybe it's because you have no where/join clause on the directory table so it's just selecting them all - you are just specifying the where on the dc table maybe try:

 $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 JOIN
 directory_categories dc WHERE dc.cat_id = $category AND d.category=dc.cat_id ORDER by d.id LIMIT $eu,
 $limit";

hth 

ali


On 04/07/2006 15:48:22, delarge (delargerock at gmail.com) wrote:
> 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/