<?php

include ('cxn/main.inc');

function dbEscape($cxn,$val)
{
  return "'".mysqli_real_escape_string($cxn,$val)."'";
}

function listFields($cxn,$tablename)
{
  $tbl=desc($cxn,$tablename);
  foreach($tbl as $fld)
  {
    echo "<p>$fld</p>";
  }
}

function loadTable($cxn,$sql)
{
#  echo $sql;
  if($result=mysqli_query($cxn,$sql))
  {
    $n=1;

    while($row=mysqli_fetch_assoc($result))
    {
      foreach($row as $field=>$value)
      {
        $table[$n][$field]=$value;
      }
      $n++;
    }

    $result->close();
  }
  else
  {
    echo "$sql <br /> Error: (" . mysqli_errno($cxn) . ") " . mysqli_error($cxn);
  }

  return $table;
}

function lookupValue($cxn,$sql)
{
  $value=null;
  if ($result=mysqli_query($cxn,$sql))
  {
  	while ($row = mysqli_fetch_row($result))
    {
  	  $value=$row[0];
  	}
    $result->close();
  }

  return $value;
}

function runSQL($cxn,$sql)
{
  if ($result=mysqli_query($cxn,$sql))
  {
    echo "Success! ";
  }

  else
  {
    echo "$sql <br /> Error: (" . mysqli_errno($cxn) . ") " . mysqli_error($cxn);
  }

  return $result;
}

function runSQLsilent($cxn,$sql)
{
  $result=mysqli_query($cxn,$sql);
  return $result;
}


?>
