From: | Killian Driscoll <killiandriscoll(at)gmail(dot)com> |
---|---|
To: | pgsql-php(at)postgresql(dot)org |
Subject: | How to limit dropdown list to options based on 'in use' rows from lookup table, for webpage using php and postgresql |
Date: | 2015-12-29 16:23:18 |
Message-ID: | CAL64pZNGxLQZ=haCh4Fu0H49VtjGPH8g7ced5Te4gorB1j7ciA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
I have a table country with a lookup table to country_type.
table country
country_id (pk), col2, col3, country_type_id (fk) integer
lookup table
country_type country_type_id (pk), type_name varchar
My lookup table has 50 country types, but only 20 are 'in use' in the
current db (with the rest possibly used later as the db expands). On the
webpage I am creating (I am using a php generator) I can set it up to add a
filter by country type based on the country type_name varchar - so one can
view the country types by name rather than the id integer - but all 50
types are listed.
I only want the 20 that currently 'in use' (not sure if this is the best
way to describe it) and therefore relevant to searches/filters (i.e. I
don't want to see a "There are no records to display" message).
What WHERE condition can I use to achieve this?
Killian Driscoll
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2015-12-29 16:35:10 | Re: How to limit dropdown list to options based on 'in use' rows from lookup table, for webpage using php and postgresql |
Previous Message | Raymond O'Donnell | 2015-11-13 13:43:49 | Re: How to Create a table in another database |