Re: [GENERAL] Complex SELECT Statement help needed

2010-02-22 Thread flashbangpop
Thanks, I got these working: $query = "SELECT lessonwebid,lessontitle,gradelevel,grademin,grademax,reviewedby FROM lessonplans WHERE grademin >= 3 AND grademin <= 5 OR grademax >= 3 AND grademax <= 5"; Raymond O'Donnell wrote: > > On 22/02/2010 18:14, flashbangpop wrote: > >> I'm new to pos

Re: [GENERAL] Complex SELECT Statement help needed

2010-02-22 Thread Raymond O'Donnell
On 22/02/2010 18:14, flashbangpop wrote: > I'm new to postgres and am trying to display rows in a table that are have a > value between 2 fields. > > The rows I want to display should be selected by the grademin or grademax > fields. I'd like to display the rows in sections that are labeled Grad