On Mon, Jun 17, 2002 at 10:46:27AM -0400, Andre Dubuc wrote:
> I'm tryiing to append entries in a db textarea field 'rbook'. Everything 
> works fine IF there is an existing entry. However, if no entries exist, it 
> nothing is written to the db. (PostgreSQL 7.2)

I'm not familliar with PostgreSQL, but it sure looks like your problem
stems from your using UPDATE queries.  If a record doesn't exist, there's
no record to update.  You need to use INSERT queries in that case.

Also, you only need one pg_connect() statement.  While that's not your 
problem, it's a waste to have them in there.  Just keep the one at the 
top.  Ditch the ones inside your if/else structure.


               PHP classes that make web design easier
        SQL Solution  |   Layout Solution   |  Form Solution
    sqlsolution.info  | layoutsolution.info |  formsolution.info
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
 4015 7 Av #4AJ, Brooklyn NY     v: 718-854-0335     f: 718-854-0409

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to