Subversion-Projekte lars-tiefland.shop_ns

Revision

Revision 16 | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
15 lars 1 
<?php
2 
    $indexes = array(
3 
        "",
4 
        2,
5 
        3,
6 
        );
7 
    mysql_connect( "localhost", "root", "NcC2007" );
8 
    mysql_select_db( "mediaran_de" );
9 
    foreach ( $indexes as $index )
10 
    {
11 
        $index_neu = $index;
12 
        if ( $index == "" )
13 
        {
14 
            $index_neu = 1;
15 
        }
16 
        $sql = "SELECT
17 
                id,
18 
                bild_url" . $index . " AS bild_url
19 
            FROM
20 
                directory
21 
            WHERE
26 lars 22 
                bild_url$index <> ''
15 lars 23 
            AND
24 
                language = 'DE'
25 
    	";
26 
        $res = mysql_query( $sql );
27 
        if ( ! $res )
28 
        {
29 
            die( mysql_error() . "\n" . $sql . "\n" );
30 
        }
31 
        while ( $row = mysql_fetch_assoc( $res ) )
32 
        {
33 
            echo "Directory " . $row["id"] . "\n";
34 
            $sql_i = "
35 
                INSERT INTO
16 lars 36 
                    directory_bild
15 lars 37 
                SET
38 
                    directory = " . $row["id"] . ",
39 
                    bild_index = $index_neu,
40 
                    url = '" . mysql_real_escape_string( $row["bild_url"] ) . "'
41 
            ";
42 
            $res_i = mysql_query( $sql_i );
43 
            if ( ! $res_i )
44 
            {
45 
                die( mysql_error() . "\n" . $sql_i . "\n" );
46 
            }
47 
        }
48 
    }
49 
?>