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.
--Dan
--
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
