Hi,

I was wondering. What is better?

INSERT a value with the OCIBindByName function like this:

$connection = //connect to database

$sql = "INSERT INTO <tablename> (column) values (:new_value)";

$stmt = OCIParse($connection,$sql) or die ("whatever");

OCIBindByName($stmt, ":new_value", &$variable, 20);

OCIExecute($stmt);

OCICommit($connection);

OCIFreeStatement($stmt);

Databasedisconnect($connection); //my own function to disconnect the database

------------------ OR VIA THIS WAY (which I prefer by the way, because the code is shorter) ----------------------------------

$sql = "INSERT INTO <tablename> (column) values ($variable)";

$stmt = OCIParse($connection,$sql) or die ("error during parsing");

OCIExecute($stmt) or die ("error during execute");

OCICommit($connection);

OCIFreeStatement($stmt);

Databasedisconnect($connection); //my own function to disconnect the database

I hope someone can tell me which one the methods above is better/faster/more efficient.

Thanx in advance.

Dj Mouse
(The Netherlands)