use sql or php code

[turbo99]

I need some help on going about the best way to achieve my data query. I will be pulling data from a table limiting it to 20 records. In that recordset there is a column that will have numeric values. Of those 20 records, the min and max values of that column need to be removed from the result set so I have the middle values to work with, so basically 18 records between the min and max values.

Can this be done using a sql query or do I have to use min and max functions using php?

thanks in advance,

Alex

[eoghain]

You might be able to do this in SQL depending on the database that you are connecting to. But if you don't know what the MIN and MAX values are going to be until you get the data back then you are best off working with PHP and just ordering your data in the query by this field and then just not displaying the first and last records.

[superwormy]

LIMIT and OFFSET

If you know you'll always be pulling 20 records, and just need to discard the highest and lowest...

MySQL < v4.0: SELECT * FROM table ORDER BY numeric_field_with_highs_and_lows LIMIT 1, 19

MySQL v4.0 or PostgreSQL: SELECT * FROM table ORDER BY numeric_field LIMIT 19 OFFSET 1

That should simply just not select the min and max values of those 20 records.