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" );