DB query dies strangley
| From: | David Dahl | Date: | Wed, 14 Aug 2002 21:50:41 +0000 |
| Subject: | DB query dies strangley | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-2116@lists.php.net to get a copy of this message | ||
I am getting an error during this PEAR DB code:
$vars = new dsn_connection();
$db = $vars->make_db_connection();
$newOwnerID = $db->nextId('owner_id');
$newOwnerDataSQL = "insert into owner (keypid,keyfassocid,namel,namef,namel2,
namef2, username, password,phone)
values
('$newOwnerID','$_SESSION[current_assoc_id]','$_POST[namel]','$_POST[namef]',
'$_POST[namel2]',
'$_POST[namef2]','$_POST[username]', '$_POST[password]',
'$_POST[phone]')";
print"$newOwnerDataSQL";
$newOwnerData = $db->query($newOwnerDataSQL);
Why would I be getting a "DB Error: already exists" error from this, and what does that
mean? I looked in the DB.php code, but couldn't find what it means...
Thanks
David