Subversion-Projekte lars-tiefland.shop_ns

<?php
    $indexes = array(
        1,
        2,
        3,
        4,
        5,
        6,
        7,
        8,
        9,
        );
    mysql_connect( "localhost", "root", "NcC2007" );
    mysql_select_db( "mediaran_de" );
    foreach ( $indexes as $index )
    {
        $sql = "SELECT
                id,
                preis$index
            FROM
                artikel
            WHERE
                father > 0
            AND
                preis$index <> 0
            AND
                language = 'DE'
        ";
        $res = mysql_query( $sql );
        while ( $row = mysql_fetch_assoc( $res ) )
        {
            echo "Artikel " . $row["id"] . "\n";
            unset( $staffel );
            $staffel["menge"][0] = 0;
            $staffel["preis"][0] = $row["preis" . $index];
            $staffel = serialize( $staffel );
            $sql_i = "
                INSERT INTO
                    preise
                SET
                    preis_index = $index,
                    artikel = " . $row["id"] . ",
                    staffel = '" . mysql_real_escape_string( $staffel ) . "'
            ";
            $res_i = mysql_query( $sql_i );
        }
    }
?>