Re: Constraint Violation when INSERT

irinchiang@justeducation.com schrieb:

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.

Don't you need to quote your strings? $sql = "INSERT INTO tutor (tutor_name, tutor_contact, tutor_email, tutor_profile)

        VALUES ('$tutor_name','$tutor_contact','$tutor_email','$tutor_profile')"; 
Martin 

------------------------------------------------------------------------------ Yes, I actually quoted my string at the beginning but whenever i do an "INSERT" it actually insert a "NULL" value into the fields...why is this so???So I try not to quote the strings but I got a "Contraints Violation" error....What could be the problem>>?? ------------------------------------------------------------------------------ Hope to get some help soon. All help are greatly appreciated. Irin.

hi, i don't know this db-class, but it seems that $db->quote() already quotes your values. so first take a look what comes from your form: <?php var_export($_POST); ?> then, take a look what this quote-method does with your vals. eg: <?php var_export($tutor_name); ?> if these vars constist of your information try to setup qour query according to mysql manual, depending on the values in your vars.