524691 Simple fast PHP/MYSQL Command-Line Query Script

I am looking for someone who can provide me with a mysql query in PHP (on command line) for the following scenario:

I have a MySQL table with the follwing 30 items:

ID, DATETIME, ITEM, STATUS (true|false)

A PHP Script should endless loop this MySQL table and check the STATUS row for each item. When an item got STATUS=FALSE, the PHP endless loop is querieng from this point (ordered by datetime) and ignoring the rest which is older (datetime). EXAMPLE:

1 14-09-2011 APPLE true

2 15-09-2011 FISH true <---

3 16-09-2011 CAR true

4 18-09-2011 ANIMAL true

i.e. at the beginning every item will be looped, and checked for the STATUS. If i.e. the item 2 "FISH" gets STATUS FALSE, only the rest of the items will be looped (from 3-4), and item 1 (Apple) not.

MySQL Odd Jobs PHP Shell Script

ID dự án: #2270630

Về dự án