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 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 having is I can't figure out how to write a >> statement >> that will check both fields. And, especially when I have values in the >> like >> this: >> >> grademin 4 grademax 12 that I want to show up in all levels >> grademin 5 grademax 12 "" >> grademin 6 grademax 9 in 6-9 and 9-12 >> >> Below is what I have so far, but it falls flat on it's face when trying >> to >> display rows that don't fall between the specific range. >> >> How can I check grademin and max in the same statement? > > Are grademin and grademax two separate columns in the table? If so, > simply imcude as many conditions as you need: > > select .... > where grademin ... > and grademax .... > and .... > > > Ray. > > > -- > Raymond O'Donnell :: Galway :: Ireland > rod@xxxxxx > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- View this message in context: http://old.nabble.com/Complex-SELECT-Statement-help-needed-tp27691760p27692084.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
