Re: script not working in php

Rodrigo Gonzalez <rjgonzale@xxxxxxxxxxxxxx> · Thu, 06 Oct 2011 09:39:59 -0300



    On 10/06/2011 09:22 AM, Robert Buckley wrote:
    
      
        Hi,
        

        this works ok in pgadmin3
        

            select name[i], kw[i]
            from ( select generate_series(1,6)
                as i, 
                          array['Biomasse',
                'Deponiegas', 'Solar', 'Wasser', 'Wind','GESAMT'] as
                name, 
                          array[biomasse_kw,
                deponiegas_kw, solar_kw,wasser_kw, wind_kw, kw] as kw
                   from
                energie.tennet_auswertung_pivot_energie ) z
            ;
          
        
        but in the php script I get error 500?
        

          $result = pg_query($connection,'
          select name[i], kw[i]
          from ( select generate_series(1,6) as
              i, 
                        array['Biomasse',
              'Deponiegas', 'Solar', 'Wasser', 'Wind','GESAMT'] as
              name, 
                        array[biomasse_kw,
              deponiegas_kw, solar_kw,wasser_kw, wind_kw, kw] as kw
                 from
              energie.tennet_auswertung_pivot_energie ) z
          ;
          '); 

            
    You have single quotes inside the query and the complete string is
    defined with single quotes too.....use double quotes to define the
    string

    
    Rodrigo