Subversion-Projekte lars-tiefland.shop_ns

<?php

    $indexes = array(

        1,

        2,

        3,

        4,

        5,

        6,

        7 );

    mysql_connect( "localhost", "root", "voyager" );

    mysql_select_db( "mediaran_de" );

    foreach ( $indexes as $index )

    {

        $sql = "SELECT

	           id,

	           bild_" . $index . "_url AS bild_url,

    	        bildunterschrift_" . $index . " AS bild_unterschrift,

	           bild_position_" . $index . " AS bild_position

	        FROM

	           artikel

    	´   WHERE

	            bild_" . $index . "_url <> ''

    	";

        $res = mysql_query( $sql );

        if ( ! $res )

        {

            die( mysql_error() . "\n" . $sql . "\n" );

        }

        while ( $row = mysql_fetch_assoc( $res ) )

        {

            echo "Artikel " . $row["id"] . "\n";

            $sql_i = "

                INSERT INTO

                    artikel_bild

                SET

                    artikel = " . $row["id"] . ",

                    bild_index = $index,

                    url = '" . mysql_real_escape_string( $row["bild_url"] ) .

                "',

                    position = '" . mysql_real_escape_string( $row["bild_position"] ) .

                "',

                    text = '" . mysql_real_escape_string( $row["bild_unterschrift"] ) .

                "'

            ";

            $res_i = mysql_query( $sql_i );

            if ( ! $res_i )

            {

                die( mysql_error() . "\n" . $sql_i . "\n" );

            }

        }

    }

?>