<?
//connect to the server
//$link = mysql_connect('localhost','','');
$link = mysql_connect('','frlht','ucy59er');
if (!$link) 
{
   die('Could not connect: ' . mysql_error());
}
//select the database
//mysql_select_db('frlhtusers') or die('Can not select database');
mysql_select_db('frlhtu') or die('Can not select database');

//SESSION
session_register('goto');
session_register('query_text');
session_register('app_date');

//generate next (unique) id.
function get_next_id($field)
{
	$sql="select $field from id_mast";
	$result=mysql_query($sql);
	$row=mysql_fetch_array($result);
	$sql="update id_mast set $field=$field+1";
	$result=mysql_query($sql);
	return $row[$field]+1;
}

function generate_valid_id($id,$maxlen)
{
	$lendif=$maxlen-strlen($id);
	for($i=0;$i<$lendif;$i++) $id='0'.$id;
	return $id;
}

function get_list_data($table,$id,$fieldary,$where='',$sql='')
{
if(!$sql) $sql="select * from $table";
if($where) $sql.=" $where";

$result=mysql_query($sql);
$ary = Array();
	while($row=mysql_fetch_array($result))
	{
		$dval='';
		foreach($fieldary as $val)
		{
			if($val=='Current_desg') $dval.="(".$row["$val"].") ";
			else $dval.=$row["$val"]." ";
		}//foreach
		$ary[$row["$id"]]=trim($dval);
	}//while
return $ary;
}

function fetch_me($table1,$fld1,$fldname,$fldvalue,$table2='',$joincondn='')
{
        if($table2=="")
        {
                $fquery="select $fld1 from $table1 where $fldname='$fldvalue'";
        }
        else
        {
         $fquery="select $fld1 from $table1 inner join $table2 on $joincondn where $fldname='$fldvalue'";
        }
        $fresult=mysql_query($fquery) or die(mysql_error());
        $frs=mysql_fetch_array($fresult);
       //print $fquery;
        //print $frs[0];
        return $frs[0];
}
function format_date_db($date)
{	$dtary = explode("/",$date);
	//print_r($dtary);
	if (count($dtary)>1)
	{
		return $dtary[2]."-".$dtary[1]."-".$dtary[0];
	}
	else
	{
		return($date);
	}
}
function format_date_db1($date)
{	$dtary = explode("-",$date);
	if (count($dtary)>0)
	{
		return $dtary[2]."-".$dtary[1]."-".$dtary[0];
	}
	else
	{
		return($date);
	}
}

?>