";
if($DB_TYPE == "MYSQL")
{
$result=mysql_query($query,$DB);
return $result;
}
if($DB_TYPE == "POSTGRESQL")
{
$result=pg_exec($DB,$query);
return $result;
}
}
function DBexecute($query)
{
global $DB,$DB_TYPE;
# echo $query,"
";
if($DB_TYPE == "MYSQL")
{
$result=mysql_query($query,$DB);
if(!$result)
{
echo "ERROR EXECUTING: $query
";
}
return $result;
}
if($DB_TYPE == "POSTGRESQL")
{
$result=pg_exec($DB,$query);
return $result;
}
}
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;
}
}
function DBget_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);
}
}
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 DBget_field($result,0,0);
}
}
?>