RE: [PHP-DB] Limiting Results

I believe you need a main table where youn list all the colleges with columns for STATE, CONGRESSIONAL DISTRICT and REPRESENTATIVE. And those three columns would be pulled from three table catalogs: STATES, CONGRESSIONAL DISTRICTS and REPRESENTATIVES. Maybe there is a better approach, but I don't

Re: [PHP-DB] Limiting Results

You could always try the LIMIT keyword :) select a.college, a.state, a.cd , b.rep from a, b where a.state = "al" and a.cd = "3" or a.state = "az" and a.cd = "1" and a.state = b.state and a.cd = b.cd LIMIT 50 -- Joseph