Code Forums - View Single Post

sde · 07-22-2004, 04:34 PM

how many results would you like to buffer? do you want to go above and below the number?

the only way i can think of is 2 queries.

Code:

select * from table where field>=$number order by field asc limit 5;
select * from table where field<$number order by field desc limit 5;

eh?

07-22-2004, 04:34 PM	#2 (permalink)
sde Moderator Join Date: May 2002 Location: us.ca Posts: 4,544	how many results would you like to buffer? do you want to go above and below the number? the only way i can think of is 2 queries. Code: select * from table where field>=$number order by field asc limit 5; select * from table where field<$number order by field desc limit 5; eh? __________________ Mike