ID: 15615 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Bogus Bug Type: PostgreSQL related Operating System: Linux PHP Version: 4.1.1 New Comment:
The bug system is not the appropriate forum for asking support questions. For a list of a range of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php Previous Comments: ------------------------------------------------------------------------ [2002-02-19 04:45:43] [EMAIL PROTECTED] im using PHP-WML and i was trying to update a table in postgres with this: <? function edit($id,$nick,$new_nick) { $sql = "UPDATE address_book SET nick='$new_nick' WHERE id=$id AND nick='$nick'"; $update = pg_exec($sql); echo("$sql"); } ?> OUTPUT ON SCREEN: UPDATE address_book SET nick='STP' WHERE id=1 AND nick='pearl jam' PGSQL DATABASE BEFORE: id | nick | email ----+-----------+------------------------ 1 | globedev | [EMAIL PROTECTED] 1 | globedev | [EMAIL PROTECTED] 1 | globedev | [EMAIL PROTECTED] 1 | globedev | [EMAIL PROTECTED] 1 | nirvana | [EMAIL PROTECTED] 1 | metallica | [EMAIL PROTECTED] 1 | pearl jam | [EMAIL PROTECTED] PGSQL DATABASE AFTER: id | nick | email ----+-----------+------------------------ 1 | globedev | [EMAIL PROTECTED] 1 | globedev | [EMAIL PROTECTED] 1 | globedev | [EMAIL PROTECTED] 1 | globedev | [EMAIL PROTECTED] 1 | nirvana | [EMAIL PROTECTED] 1 | metallica | [EMAIL PROTECTED] 1 | | [EMAIL PROTECTED] ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=15615&edit=1
