Subversion-Projekte lars-tiefland.shop_ns

<?php
        $indexes = array( 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
                father > 0
            AND
                bild_" . $index . "_url <> ''
        ";
        $res = mysql_query($sql);
        echo mysql_error()."\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 );
            echo mysql_error()."\n";
        }
        }
?>