Subversion-Projekte lars-tiefland.shop_ns

Revision

Revision 9 | Revision 12 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 9 Revision 10
Zeile 1... Zeile 1...
1 
<?php
 1 
<?php
2 
        $indexes = array( 2, 3, 4, 5, 6, 7 );
 2 
    $indexes = array(
- 
 
 3 
        1,
- 
 
 4 
        2,
- 
 
 5 
        3,
- 
 
 6 
        4,
- 
 
 7 
        5,
- 
 
 8 
        6,
- 
 
 9 
        7 );
3 
	mysql_connect("localhost","root","voyager");
 10 
    mysql_connect( "localhost", "root", "voyager" );
4 
	mysql_select_db("mediaran_de");
 11 
    mysql_select_db( "mediaran_de" );
5 
	foreach( $indexes as $index )
 12 
    foreach ( $indexes as $index )
6 
	{
 13 
    {
7 
	$sql="
 - 
 
8 
	    SELECT
 14 
        $sql = "SELECT
9 
	        id,
 15 
	           id,
10 
	        bild_" . $index . "_url AS bild_url,
 16 
	           bild_" . $index . "_url AS bild_url,
11 
	        bildunterschrift_" . $index . " AS bild_unterschrift,
 17 
    	        bildunterschrift_" . $index . " AS bild_unterschrift,
12 
	        bild_position_" . $index . " AS bild_position
 18 
	           bild_position_" . $index . " AS bild_position
13 
	    FROM
 19 
	        FROM
14 
	        artikel
 20 
	           artikel
15 
	´   WHERE
 21 
    	´   WHERE
16 
	        father > 0
 - 
 
17 
	    AND
 - 
 
18 
	        bild_" . $index . "_url <> ''
 22 
	            bild_" . $index . "_url <> ''
19 
	";
 23 
    	";
20 
	$res = mysql_query($sql);
 24 
        $res = mysql_query( $sql );
- 
 
 25 
        if ( ! $res )
- 
 
 26 
        {
21 
	echo mysql_error()."\n";
 27 
            die( mysql_error() . "\n" . $sql . "\n" );
- 
 
 28 
        }
22 
	while($row=mysql_fetch_assoc($res))
 29 
        while ( $row = mysql_fetch_assoc( $res ) )
23 
	{
 30 
        {
24 
	    echo "Artikel " . $row["id"] . "\n";
 31 
            echo "Artikel " . $row["id"] . "\n";
25 
	    $sql_i="
 32 
            $sql_i = "
26 
	        INSERT INTO
 33 
                INSERT INTO
27 
		    artikel_bild
 34 
                    artikel_bild
28 
		SET
 35 
                SET
29 
		    artikel = " . $row["id"] . ",
 36 
                    artikel = " . $row["id"] . ",
30 
		    bild_index = $index,
 37 
                    bild_index = $index,
31 
		    url = '" . mysql_real_escape_string( $row["bild_url"] ) . "',
 38 
                    url = '" . mysql_real_escape_string( $row["bild_url"] ) .
- 
 
 39 
                "',
32 
		    position = '" . mysql_real_escape_string( $row["bild_position"] )."',
 40 
                    position = '" . mysql_real_escape_string( $row["bild_position"] ) .
- 
 
 41 
                "',
33 
		    text = '" . mysql_real_escape_string( $row["bild_unterschrift"] )."'
 42 
                    text = '" . mysql_real_escape_string( $row["bild_unterschrift"] ) .
- 
 
 43 
                "'
34 
            ";
 44 
            ";
35 
	    $res_i = mysql_query( $sql_i );
 45 
            $res_i = mysql_query( $sql_i );
36 
	    echo mysql_error()."\n";
 46 
            if ( ! $res_i )
- 
 
 47 
            {
- 
 
 48 
                die( mysql_error() . "\n" . $sql_i . "\n" );
- 
 
 49 
            }
37 
	}
 50 
        }
38 
	}
 51 
    }
39 
?>
 52 
?>