Simple Mysql query I think !!!

[Anon]

hello,
I am looking for a php code that can perform the following:
based on this mysql db

2002-08-01 val1 test1 TEST val2 5
2002-08-02 val1 test1 TEST val2 5
2002-08-03 val1 test2 TEST val2 5
2002-08-03 val1 test8 TEST val2 3
2002-08-03 val1 test2 TEST val2 0
2002-08-03 val1 test3 TEST val2 9
2002-08-04 val1 test8 TEST val2 6
2002-08-04 val1 test3 TEST val2 5
2002-08-04 val1 test3 TEST val2 5
2002-08-03 val1 test8 TEST val2 6
2002-08-05 val1 test3 TEST val2 0

I need to be able to only show all results from column 3 that has value > 1 from last column and must not have any other vaule in column 5 that is < 2 in same day also occured 3 days in a row based on last date from column 1

so the result if query above table will be this:
2002-08-04 val1 test8 TEST val2 6

I really appreciate any help ..
Thanks in a dvance....

[Anon]

Sorry, db was wrong above ..this one below:

2002-08-01 val1 test1 TEST val2 5
2002-08-02 val1 test1 TEST val2 5
2002-08-03 val1 test2 TEST val2 5
2002-08-03 val1 test8 TEST val2 3
2002-08-03 val1 test2 TEST val2 0
2002-08-03 val1 test3 TEST val2 9
2002-08-04 val1 test8 TEST val2 6
2002-08-04 val1 test3 TEST val2 5
2002-08-04 val1 test3 TEST val2 5
2002-08-03 val1 test8 TEST val2 6
2002-08-05 val1 test3 TEST val2 0
2002-08-05 val1 test8 TEST val2 8

I need to be able to only show all results from column 3 that has value > 1 from last column and must not have any other vaule in column 5 that is < 2 in same day also occured 3 days in a row based on last date from column 1

so the result if query above table will be this:

2002-08-04 val1 test8 TEST val2 6