sql-daten

Array
(
    [262] => 1600
    [33] => 3400
    [304] => 2800
    [94] => --
    [21] => --
    [22] => --
)

=========================================
SELECT
                    searchlist_properties.id
                  FROM
                    searchlist_machine_property, searchlist_properties
                  WHERE
                    searchlist_machine_property.fk_machine = '58'
                  AND
                    searchlist_machine_property.fk_property = searchlist_properties.id
                  AND
                    searchlist_properties.fk_type = '262'
-----------------------------------------
-----------------------------------------
UPDATE
	                        searchlist_properties
	                      SET
	                        value = '1600'
	                      WHERE
	                        id = '398'
	                      LIMIT 1
-----------------------------------------
SELECT
                    searchlist_properties.id
                  FROM
                    searchlist_machine_property, searchlist_properties
                  WHERE
                    searchlist_machine_property.fk_machine = '58'
                  AND
                    searchlist_machine_property.fk_property = searchlist_properties.id
                  AND
                    searchlist_properties.fk_type = '33'
-----------------------------------------
-----------------------------------------
UPDATE
	                        searchlist_properties
	                      SET
	                        value = '3400'
	                      WHERE
	                        id = '397'
	                      LIMIT 1
-----------------------------------------
SELECT
                    searchlist_properties.id
                  FROM
                    searchlist_machine_property, searchlist_properties
                  WHERE
                    searchlist_machine_property.fk_machine = '58'
                  AND
                    searchlist_machine_property.fk_property = searchlist_properties.id
                  AND
                    searchlist_properties.fk_type = '304'
-----------------------------------------
-----------------------------------------
UPDATE
	                        searchlist_properties
	                      SET
	                        value = '2800'
	                      WHERE
	                        id = '396'
	                      LIMIT 1
-----------------------------------------
SELECT
                    searchlist_properties.id
                  FROM
                    searchlist_machine_property, searchlist_properties
                  WHERE
                    searchlist_machine_property.fk_machine = '58'
                  AND
                    searchlist_machine_property.fk_property = searchlist_properties.id
                  AND
                    searchlist_properties.fk_type = '94'
-----------------------------------------
-----------------------------------------
UPDATE
	                        searchlist_properties
	                      SET
	                        value = '--'
	                      WHERE
	                        id = '400'
	                      LIMIT 1
-----------------------------------------
SELECT
                    searchlist_properties.id
                  FROM
                    searchlist_machine_property, searchlist_properties
                  WHERE
                    searchlist_machine_property.fk_machine = '58'
                  AND
                    searchlist_machine_property.fk_property = searchlist_properties.id
                  AND
                    searchlist_properties.fk_type = '21'
-----------------------------------------
-----------------------------------------
UPDATE
	                        searchlist_properties
	                      SET
	                        value = '--'
	                      WHERE
	                        id = '401'
	                      LIMIT 1
-----------------------------------------
SELECT
                    searchlist_properties.id
                  FROM
                    searchlist_machine_property, searchlist_properties
                  WHERE
                    searchlist_machine_property.fk_machine = '58'
                  AND
                    searchlist_machine_property.fk_property = searchlist_properties.id
                  AND
                    searchlist_properties.fk_type = '22'
-----------------------------------------
-----------------------------------------
UPDATE
	                        searchlist_properties
	                      SET
	                        value = '--'
	                      WHERE
	                        id = '399'
	                      LIMIT 1
-----------------------------------------