Re: Looking for help

 Use quotes around the field and table names that are not all lower case:

Ex:
$result = pg_query($db," Select 'Field1',field2, 'fEild3' From'TABLE1' ");



Patrick Hatcher





                            
                    Joseph L Montes
                            
                    <jmontes@zenplex.com       To:     pgsql-php@postgresql.org
                            
                    >                          cc:
                            
                    Sent by:                   Subject:     [PHP] Looking for help
                            
                    pgsql-php-owner@post
                            
                    gresql.org
                            

                            

                            
                    08/27/2002 03:56 PM
                            

                            




I am new to combining PHP and Postgres. I am able to Select and create
tables by using the Select * From "table" command fine, but What happens
if I only want to select a couple of fields. How do I go about this.
also how do you select from a table that is not all lower case. Granted
this is probably quite simple, but I am new to this. thanks ewveryone
--
Joseph L Montes
Senior Systems Engineer
Zenplex Inc.
317 Madison Ave. suite 1500
New York New York
V(212)499-0668 Ext. 203
F(646)865-0783
http://www.zenplex.com
http://www.zenplex.org
http://www.tambora.org


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html