note 1531 deleted from pg_Exec by jmoore
| From: | jmoore@php.net | Date: | Fri, 18 Aug 2000 22:56:41 +0000 |
| Subject: | note 1531 deleted from pg_Exec by jmoore | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-2528@lists.php.net to get a copy of this message | ||
(Boy this text window is small)
First, the note with the "... ), (..." is incorrect. The comma should be removed. The
other problem is likely the data type you are sending. If you try to insert a '9' into a
int4 you do get an error message.
<PRE>
$sqlq =
"INSERT INTO reviewers "
." ( name, email, webpage, passcode, ipaddress, alias, "
." phone, city, state, country, clearance ) "
." VALUES ('$name', '$email', '$webpage',
'$passcode', "
." '$ipaddress', '$alias', '$phone', '$city',
'$state', "
." '$country', $clearance );";
$e = pg_exec($db,$sqlq);
</PRE>