Re: Limiting Results
| From: | Joseph Crawford | Date: | Thu, 19 May 2005 13:28:03 +0000 |
| Subject: | Re: Limiting Results | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39506@lists.php.net to get a copy of this message | ||
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