RE: [PHP] help with query

Thanks Jim, worked like a charm. > -----Original Message----- > From: Jim Lucas [mailto:lists@cmsws.com] > Sent: Thursday, June 07, 2012 4:08 PM > To: Jack > Cc: PHP > Subject: Re: [PHP] help with query > > On 06/07/2012 09:37 AM, Jack wrote: > > $query = "select a.startdate, a.articleid, c.name, a.title, a.intro, > > a.datecreated from articles as a, categories as c where (a.startdate = > > -1 or a.startdate<= {$now}) and (a.enddate = -1 or a.enddate>= {$now}) > > and a.categoryid = c.categoryid order by a.startdate DESC"; > > $query = " > SELECT a.startdate, > a.articleid, > c.name, > a.title, > a.intro, > a.datecreated > FROM articles as a, > categories as c > WHERE ( > a.startdate = -1 > OR > a.startdate <= {$now} > ) > AND ( > a.enddate = -1 > OR > a.enddate >= {$now} > ) > -- This line must stay, it is limiting the combination of the data from > -- both tables > AND a.categoryid = c.categoryid > -- You need to add this line to make it work, but keep the previous line > AND a.categoryid = 1 > > ORDER BY a.startdate DESC > "; > > -- > Jim Lucas > > http://www.cmsws.com/ > http://www.cmsws.com/examples/ > http://www.bendsource.com/