<?php
$dbname = "thisgene_sitearticles"; // Place the database name here
$tablename = "encounters"; // Table name here
$dbconnect = mysql_connect ("localhost", "thisgene_porter",
"password") or die(mysql_error());
$db = @mysql_select_db($dbname, $dbconnect);
$sql = "INSERT INTO $tablename (script_title, script, content_title, content) VALUES
('$_POST[script_title]', '$_POST[script]', '$_POST[content_title]',
'$_POST[content]')";
$result = @mysql_querry($sql, $dbconnect) or die(mysql_error());
?>
try this:
$sql = "INSERT INTO ".$xoopsDB->prefix("encounters")." (script_title, script, content_title, content) VALUES
('$_POST[script_title]', '$_POST[script]', '$_POST[content_title]',
'$_POST[content]')";
$result = $xoopsDB->query($sql) or die(mysql_error());
There is a database class and object ready to use - might as well use that
If it ain't working, try enabling first PHP debug and if no errors, then MySQL debug and see, where the problem is
GL