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 );

        }

    }

?>