Change multi lines

[Ervin]

Hello!

 

I need small help. Need php script for changinh milti lines in myslq database. In database are fiekds: date, ip, status

1. 2014-09-01, 123, 0

2. 2014-09-01, 444, 0

3. 2014-09-01, 123, 0

4. 2014-08-31, 888, 0

5. 2014-09-01, 444, 0

6. 2014-09-01, 123, 0

 

Now script must search ip and date.

 

1. record is OK,

2. record is OK,

3. record NOT OK, because date and ip are in first record, must change status to 1

4. record is OK,

5. record NOT OK, because date and ip are in second record, must change status to 1

6. record NOT OK, because date and ip are in 1 and 3 record, must change status to 1