Re: [PHP-DB] Limiting Results

You could always try the LIMIT keyword :)

select a.college, a.state, a.cd <http://a.cd/>, b.rep from a, b

where

a.state = "al" and a.cd <http://a.cd/> = "3" or
a.state = "az" and a.cd <http://a.cd/> = "1" and

a.state = b.state and
a.cd <http://a.cd/> = b.cd <http://b.cd/>

LIMIT 50

-- 
Joseph Crawford Jr.
Codebowl Solutions
codebowl@gmail.com