";
if($DB_TYPE == "MYSQL")
{
$result=mysql_query($query,$DB);
if(!$result)
{
echo "Error in query [$query] [".mysql_error()."]";
}
return $result;
}
if($DB_TYPE == "POSTGRESQL")
{
$result=pg_exec($DB,$query);
return $result;
}
}
function DBexecute($query, $skip_error_messages=0)
{
global $DB,$DB_TYPE;
# echo $query."
";
if($DB_TYPE == "MYSQL")
{
$result=mysql_query($query,$DB);
if(!$result && $skip_error_messages==0)
{
error("SQL error: ".mysql_error());
error("Query: $query");
}
return $result;
}
if($DB_TYPE == "POSTGRESQL")
{
$result=pg_exec($DB,$query);
return $result;
}
return FALSE;
}
function DBfetch($result)
{
global $DB_TYPE;
if($DB_TYPE == "MYSQL")
{
$row=mysql_fetch_array($result);
return $row;
}
if($DB_TYPE == "POSTGRESQL")
{
$row=pg_fetch_array($result);
return $row;
}
return FALSE;
}
function get_field($result,$rownum,$fieldnum)
{
global $DB_TYPE;
if($DB_TYPE == "MYSQL")
{
mysql_data_seek($result,$rownum);
$row=mysql_fetch_row($result);
return $row[$fieldnum];
}
if($DB_TYPE == "POSTGRESQL")
{
$row=pg_fetch_row($result,$rownum);
if(!$row)
{
echo "Error getting row";
exit;
}
return $row[$fieldnum];
}
}
function DBnum_rows($result)
{
global $DB_TYPE;
if($DB_TYPE == "MYSQL")
{
return mysql_num_rows($result);
}
if($DB_TYPE == "POSTGRESQL")
{
return pg_numrows($result);
}
return 0;
}
function DBinsert_id($result,$table,$field)
{
global $DB,$DB_TYPE;
if($DB_TYPE == "MYSQL")
{
return mysql_insert_id($DB);
}
if($DB_TYPE == "POSTGRESQL")
{
$oid=pg_getlastoid($result);
// echo "OID:$oid
";
$sql="select $field from $table where oid=$oid";
$result=DBselect($sql);
return get_field($result,0,0);
}
}
?>