<?php

// ########################## SELECT 1 ͹ STEP ########################
function select_query($sfield, $tables, $wfield, $ids, $condition = NULL) {
  $sql = "SELECT $sfield FROM $tables WHERE $wfield='$ids' $condition";
  $result = mysql_query($sql);
  $data = mysql_fetch_array($result);
  return $data;
  mysql_close($handle);
}

// ########################## SELECT 1 ͹ STEP ########################
function select_query_object($sfield, $tables, $wfield, $ids, $condition = NULL) {
  $sql = "SELECT $sfield FROM $tables WHERE $wfield='$ids' $condition";

  $result = mysql_query($sql);
  $data = mysql_fetch_object($result);
  return $data;
  mysql_close($handle);
}

// ########################## SELECT result ########################
function select_result_query($sfield, $tables, $wfield, $ids, $condition = NULL) {
  $sql = "SELECT $sfield FROM $tables WHERE $wfield=$ids $condition";
  $result = mysql_query($sql);
  return $result;
  mysql_close($handle);
}

// ########################## SELECT spacific 1 data ########################
function select_query_data($sfield, $tables, $wfield, $ids, $condition = NULL, $debug = NULL) {
  if ($debug != NULL)
    echo $sql = "SELECT $sfield FROM $tables WHERE $wfield='$ids' $condition";
  else
    $sql = "SELECT $sfield FROM $tables WHERE $wfield='$ids' $condition";
  $result = mysql_query($sql);
  $data = mysql_fetch_object($result);
  return $data->$sfield;
  mysql_close($handle);
}

// ######################### SELECT MAX 1 ͹ STEP ####################
function select_max_query($sfield, $tables, $wfield, $ids) {
  $sql = "select max($sfield+1) from $tables WHERE $wfield='$ids'";
  $result = mysql_query($sql);
  $data = mysql_fetch_array($result);
  return $data;
  mysql_close($handle);
}

// ######################### SELECT MAX 0 ͹ STEP ####################
function select_max_query0($sfield, $tables, $wclause = NULL) {
  if ($wclause != NULL)
    $sql = "select max($sfield+1) from $tables WHERE $wclause";
  else
    $sql = "select max($sfield+1) from $tables";
  $result = mysql_query($sql);
  $data = mysql_fetch_array($result);
  return $data;
  mysql_close($handle);
}

// ######################### COUNT  ####################
function select_count($sfield, $tables, $wclause = NULL) {
  if ($wclause != NULL)
    $sql = "select COUNT($sfield) as t from $tables WHERE $wclause";
  else
    $sql = "select COUNT($sfield) as t from $tables";
  $result = mysql_query($sql);
  $data = mysql_fetch_array($result);

  return $data[t];
  mysql_close($handle);
}

// ######################## UPDATE 1 ͹ STEP #########################
function update_query($tables, $sfield, $okfield, $wfield, $ids) {
  $sql = "UPDATE $tables SET $sfield='$okfield' WHERE $wfield='$ids'";
  $result = mysql_query($sql);
  return true;
  mysql_close($handle);
}

// ######################## DELETE 5 Field ###############################
function delete_query($f1, $f2, $f3, $f4, $f5, $field, $wfield, $ids) {
  $sql = "select $f1,$f2,$f3,$f4,$f5 from $field where $wfield='$ids'";
  $result = mysql_query($sql);
  $data = mysql_fetch_row($result);
  if ($data[0] != "") {
    unlink("$_SESSION[web_name]/mainfile/$data[0]");
  }
  if ($data[1] != "") {
    unlink("$_SESSION[web_name]/mainfile/$data[1]");
  }
  if ($data[2] != "") {
    unlink("$_SESSION[web_name]/mainfile/$data[2]");
  }
  if ($data[3] != "") {
    unlink("$_SESSION[web_name]/mainfile/$data[3]");
  }
  if ($data[4] != "") {
    unlink("$_SESSION[web_name]/mainfile/$data[4]");
  }
  $sql = "delete from $field where $wfield='$ids'";
  $result = mysql_query($sql) or die(mysql_error());
  return true;
  mysql_close($handle);
}

// ######################## INSERT QUERY ###############################
function query($sql, $error = FALSE) {
  if ($error == FALSE)
    $result = mysql_query($sql) or die(mysql_error());
  else
    $result = mysql_query($sql);

  return ($result);
  mysql_close($handle);
}
?>