Drop result rows

MrWizard

I need to drop results based on greater and less than query. I will try to explain...

I queried the database for the results that are less than 'value'... the problem I have now is that some of those rows need to not be displayed if they also have values between the less than value and a larger value.

Searched and received all records where num<='7' - now working and displaying

now I need to drop any any rows where num is between 8 and 10 and only display the ones that are <='7'

Is there a simple query or if statement to allow this??

doing all of this in PHP by the way.

laserlight

I do not really understand this: if you are only selecting those rows for which num <= 7, how can it be that you also retrieve rows for which num is between 8 and 10?

MrWizard

Because there are entries for the same id with bigger nums and ids with smaller. I have grouped them together in the query.

I guess what I am looking for is something along the lines of another query perhaps or an IF statement that loops thru the id row of the intial results, checks to see if any of those ids also have entries that are say between 8 and 10 and ignores them producing only ids that have the last num less then <=7

The ids have multiple entries with different num values.

Am i just making this more confusing? lol

Pikachu2000

Perhaps it would be best to provide an example of the data and fields you're retrieving, and an explanation of exactly what result you're trying to end up with . . .

MrWizard

I will try again...

$result = mysql_query("SELECT FROM (SELECT FROM scheduledjobs WHERE date<=$lastdate GROUP BY propid ORDER BY date DESC) AS foo ORDER BY date DESC");

Date is varchar and entries are formatted like: mm/dd/yyyy and the above gives the last entry in the date column but there might be entries that are greater than the $lastdate and I don't want those propid's printed...

Basically if the last entry for the propid in the above query gives me also has dates after the $lastdate. I don't want those returned...