Subversion-Projekte lars-tiefland.shop_ns

Revision

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

Revision 13 Revision 14
Zeile 4... Zeile 4...
4
        2,
4
        2,
5
        3,
5
        3,
6
        4,
6
        4,
7
        5,
7
        5,
8
        6,
8
        6,
-
 
9
        7,
9
        7 );
10
        );
10
    mysql_connect( "localhost", "root", "NcC2007" );
11
    mysql_connect( "localhost", "root", "NcC2007" );
11
    mysql_select_db( "mediaran_de" );
12
    mysql_select_db( "mediaran_de" );
12
    foreach ( $indexes as $index )
13
    foreach ( $indexes as $index )
13
    {
14
    {
14
        $sql = "SELECT
15
        $sql = "SELECT
15
	           id,
16
                id,
16
	           bild_" . $index . "_url AS bild_url,
17
                bild_" . $index . "_url AS bild_url,
17
               bildunterschrift_" . $index . " AS bild_unterschrift,
18
                bildunterschrift_" . $index . " AS bild_unterschrift,
18
	           bild_position_" . $index . " AS bild_position
19
                bild_position_" . $index . " AS bild_position
19
	        FROM
20
            FROM
20
	           artikel
21
                artikel
21
    	´   WHERE
22
            WHERE
22
	            bild_" . $index . "_url <> ''
23
                bild_" . $index . "_url <> ''
23
             AND
24
            AND
24
                language = 'DE'
25
                language = 'DE'
25
    	";
26
    	";
26
        $res = mysql_query( $sql );
27
        $res = mysql_query( $sql );
27
        if ( ! $res )
28
        if ( ! $res )
28
        {
29
        {