Subversion-Projekte lars-tiefland.shop_ns

Revision

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

Revision 11 Revision 12
Zeile 8... Zeile 8...
8 
        6,
 8 
        6,
9 
        7,
 9 
        7,
10 
        8,
 10 
        8,
11 
        9,
 11 
        9,
12 
        );
 12 
        );
13 
    mysql_connect( "localhost", "root", "voyager" );
 13 
    mysql_connect( "localhost", "root", "NcC2007" );
14 
    mysql_select_db( "mediaran_de" );
 14 
    mysql_select_db( "mediaran_de" );
15 
    foreach ( $indexes as $index )
 15 
    foreach ( $indexes as $index )
16 
    {
 16 
    {
17 
        $sql = "SELECT
 17 
        $sql = "SELECT
18 
                id,
 18 
                id,
Zeile 21... Zeile 21...
21 
                artikel
 21 
                artikel
22 
            WHERE
 22 
            WHERE
23 
                father > 0
 23 
                father > 0
24 
            AND
 24 
            AND
25 
                preis$index <> 0
 25 
                preis$index <> 0
- 
 
 26 
            AND
- 
 
 27 
                language = 'DE'
26 
        ";
 28 
        ";
27 
        $res = mysql_query( $sql );
 29 
        $res = mysql_query( $sql );
28 
        while ( $row = mysql_fetch_assoc( $res ) )
 30 
        while ( $row = mysql_fetch_assoc( $res ) )
29 
        {
 31 
        {
30 
            echo "Artikel " . $row["id"] . "\n";
 32 
            echo "Artikel " . $row["id"] . "\n";