[GENERAL] Complex SELECT Statement help needed

2010-02-22 Thread flashbangpop
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 Grades 3-5, 6-8, and 9-12. The problem that I am

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 Grades

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