INSERT problem--Need help urgently

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi all:

I was having some problem with INSERT query here and do hope to get some help 
real soon.

I have a form whereby once the form is submitted, the values entered shall be 
inserted into the database. Next I have also written a SELECT query to view the 
records which have just been inserted into the database. 

Data was able to insert into the database and I was also able to retrieve these 
data from database. However, my problem is, whenever a form was being 
submitted, it actually INSERT another row of null values into the database. And 
so, when I clicked to view my data, i can see the previously inserted values as 
well as an empty row of records. 

Why is this so? How can I prevent the row of null value to be inserted?

I have included a snip of my code below and hope to get some help real soon. 
All help are greatly appreciated. Thanks in advance.

<snip>

$dsn = "mysql://root:password@localhost/databaseName";

$db = DB::connect ($dsn);
   if (DB::isError ($db))
       die ($db->getMessage());

$tutor_name = $_POST["tutor_name"];
$tutor_contact = $_POST["tutor_contact"];
$tutor_email = $_POST["tutor_email"];
$tutor_profile = $_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());
}

?>

</snip>

Is there anything wrong with my SELECT query ??

Thanks in advance.

Regards, 
Irin

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux