Devam Ediyor

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.

Beceriler: Her şey Kabul, MySQL, PHP, Kabuk Betiği

Daha fazlasını görün: php checked checked, ignoring someone, car id, example shell script, simple rest, simple query, php command, mysql query, looped, line-following, command, Apple script, apple car, command line apple, query loop, php loop command, simple loop command, command command, mysql php rest, check table mysql script, datetime, loop table, apple check, shell script mysql, rest php mysql

İşveren Hakkında:
( 5 değerlendirme ) MZ, Germany

Proje NO: #2270630