Re: Constraint Violation when INSERT

>>> 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:**********@localhost/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.