>>> Hi all,
>>> I got the error " Constraint Violation " when I did an "INSERT" .
>>> Gone thru the code umpteen times but to no avail..Wondering where my
>>> error was??...Below is a snip of the block of code:
>>> ---------------------------------------------------- <? $dsn =
>>> "mysql://root:[EMAIL PROTECTED]/tablename";
>>> $db = DB::connect ($dsn); if (DB::isError ($db)) die
>>> ($db->getMessage());
>>>
>>> //create variables ready to go into DB
>>> $tutor_name = $db->quote($_POST["tutor_name"]); $tutor_contact =
>>> $db->quote($_POST["tutor_contact"]); $tutor_email =
>>> $db->quote($_POST["tutor_email"]); $tutor_profile =
>>> $db->quote($_POST["tutor_profile"]);
>>>
>>> $sql = "INSERT INTO tutor (tutor_name, tutor_contact, tutor_email,
>>> tutor_profile) VALUES
>>> ($tutor_name,$tutor_contact,$tutor_email,$tutor_profile)";
>>>
>>> $result = $db->query($sql); if( DB::isError($result) ) { die
>>> ($result->getMessage()); } ?>
>>> --------------------------------------------------------------
>>> --------- Everything was fine and the "INSERT" works, user input was
>>> insert into the database successful using the same block of code but
>>> the next thing i know I got this error ....anyone know watz the proz
>>> here??? Hope to get some help soon. Thanks in advance=)
>>> Irin.
>>
It looks like you have a constraint in your table, ie some of the values
must correspond to another receord of another table for example... Could
you post a MySQL description of your table ?
-------------------------------------------------------------------------------
But I was only trying out the script using one table and that is why there's
no way I can have some of my values corresponding to another table...
I'm quite a newbie to database design, so having only one table meaning i cant
reference my primary to a foreign key in another table and that's y I got
this "constraint" error here??Am i right to say that??
Hope to get some help real soon...thanks in advance =)
A desc of my table:"tutor"
+---------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+----------------+
| tutor_id | int(11) | | PRI | NULL | auto_increment |
| tutor_name | varchar(255) | | | | |
| tutor_contact | varchar(12) | | | | |
| tutor_email | varchar(255) | | | | |
| tutor_profile | text | | | | |
+---------------+--------------+------+-----+---------+----------------+
Irin.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
