Subversion-Projekte lars-tiefland.shop_ns

Revision

Revision 14 | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 14 Revision 15
Zeile 10... Zeile 10...
10
        );
10
        );
11
    mysql_connect( "localhost", "root", "NcC2007" );
11
    mysql_connect( "localhost", "root", "NcC2007" );
12
    mysql_select_db( "mediaran_de" );
12
    mysql_select_db( "mediaran_de" );
13
    foreach ( $indexes as $index )
13
    foreach ( $indexes as $index )
14
    {
14
    {
-
 
15
        $typ = "Bild";
-
 
16
        if ( $index == 3 )
-
 
17
        {
-
 
18
            $typ = "Video";
-
 
19
        }
-
 
20
        elseif ( $index == 4 )
-
 
21
        {
-
 
22
            $typ = "Dokument";
-
 
23
        }
15
        $sql = "SELECT
24
        $sql = "SELECT
16
                id,
25
                id,
17
                bild_" . $index . "_url AS bild_url,
26
                bild_" . $index . "_url AS bild_url,
18
                bildunterschrift_" . $index . " AS bild_unterschrift,
27
                bildunterschrift_" . $index . " AS bild_unterschrift,
19
                bild_position_" . $index . " AS bild_position
28
                bild_position_" . $index . " AS bild_position
Zeile 41... Zeile 50...
41
                    url = '" . mysql_real_escape_string( $row["bild_url"] ) .
50
                    url = '" . mysql_real_escape_string( $row["bild_url"] ) .
42
                "',
51
                "',
43
                    position = '" . mysql_real_escape_string( $row["bild_position"] ) .
52
                    position = '" . mysql_real_escape_string( $row["bild_position"] ) .
44
                "',
53
                "',
45
                    text = '" . mysql_real_escape_string( $row["bild_unterschrift"] ) .
54
                    text = '" . mysql_real_escape_string( $row["bild_unterschrift"] ) .
46
                "'
55
                "',
-
 
56
                    typ = '" . $typ . "'
47
            ";
57
            ";
48
            $res_i = mysql_query( $sql_i );
58
            $res_i = mysql_query( $sql_i );
49
            if ( ! $res_i )
59
            if ( ! $res_i )
50
            {
60
            {
51
                die( mysql_error() . "\n" . $sql_i . "\n" );
61
                die( mysql_error() . "\n" . $sql_i . "\n" );