PHP SelectDataWhere函数代码示例

<?php 
        } elseif ($gf[2] == '2') {
            //formula
            eval("\$tfee={$ft['1']}{$gf['3']};");
            ?>
        <td><?php 
            echo number_format($tfee, 2);
            ?>
</td>
<?php 
        } elseif ($gf[2] == '3') {
            //range
            $getr = SelectDataWhere($dbtype, $dbLink, "culture_range", "where\n\t\t\tculture_id={$getengine211['culture_id']} and range_lower<={$ft['1']} and\n\t\t\trange_higher >= {$ft['1']}");
            $numr = NumRows($dbtype, $getr);
            if ($numr == 0) {
                $getr = SelectDataWhere($dbtype, $dbLink, "culture_range", "where\n                        culture_id={$getengine211['culture_id']} and range_lower<={$ft['1']} and\n                        range_higher = '0'");
            }
            $getre = FetchArray($dbtype, $getr);
            if (is_numeric($getre[amt])) {
                ?>
				<td><?php 
                $tfee = $getre[amt];
                echo number_format($getre[amt], 2);
                ?>
</td>
<?php 
            } else {
                eval("\$tfee={$ft['1']}{$getre['amt']};");
                ?>
        <td><?php 
                echo number_format($tfee, 2);

              <td align="right" valign="top" class='normal' colspan=4>&nbsp; </td>
            </tr>
	<?php 
//if ($owner_id<>'' and $business_id<>'') {
$ic = 0;
$col1 = 0;
$getreq = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_requirements", "where recstatus='A' and reqindicator='1' and permit_type='Business'");
$gt = NumRows($dbtype, $getreq);
while ($ic < $gt) {
    while ($getr = FetchRow($dbtype, $getreq)) {
        $ic++;
        if ($col1 == 0) {
            include 'tablecolor-inc.php';
            print "<tr bgcolor='{$varcolor}'>\n";
        }
        $check1 = SelectDataWhere($dbtype, $dbLink, "havereq", " where owner_id={$owner_id}\n                                   \tand business_id={$business_id} \n\t\t\t\t\tand reqid={$getr['0']}");
        $hreq = NumRows($dbtype, $check1);
        if ($hreq == 0) {
            $insertreq = InsertQuery($dbtype, $dbLink, "havereq", "", "'', {$getr['0']}, {$owner_id}, {$business_id},0");
            $ch = 'UNCHECKED';
            $gethr[4] = 0;
        } else {
            $gethr = FetchRow($dbtype, $check1);
            if ($gethr[4] == 1) {
                $ch = 'CHECKED';
            } else {
                $ch = 'UNCHECKED';
            }
        }
        $getr[1] = stripslashes($getr[1]);
        print "\t\n\t\t\t\t<td align=right width=5%><input type=hidden name=colre[{$ic}] \n\t\t\t\tvalue={$getr['0']}>&nbsp \n\t\t\t\t<input type=checkbox name=x[{$ic}] {$ch}></td><td align=left width=23%>{$getr['1']}\n\t\t\t\t</td>";

 $ry = $rt["iReset"];
 if ($ry == '1') {
     $getpyr = mysql_query("select * from {$permittable} order by {$incode} desc");
     $gt = mysql_fetch_assoc($getpyr);
     $anoba = $gt["for_year"];
     if ($anoba == date('Y')) {
         //get total number of permit released
         $curyr = date('Y');
         $gettotal = SelectDataWhere($dbtype, $dbLink, $permittable, "where released = 1 and for_year = '{$curyr}'");
         $gettot = NumRows($dbtype, $gettotal);
     } else {
         $gettot = 0;
     }
 } else {
     //get total number of permit released
     $gettotal = SelectDataWhere($dbtype, $dbLink, $permittable, "where released = 1");
     $gettot = NumRows($dbtype, $gettotal);
 }
 $sequence = $getcode[2];
 $sequence = '100000000000' + $sequence;
 $sequence = $sequence + $gettot + 1;
 $sequence = substr($sequence, 1, 11);
 if ($getcode[1] == '1') {
     // check if have date
     $permitnumber = $getcode[0] . "-" . $currdate[year] . "-" . $sequence;
 } else {
     $permitnumber = $getcode[0] . "-" . $sequence;
 }
 if ($permit_type != 'Business') {
     //insert permitcode to $permittable
     $updateit = UpdateQuery($dbtype, $dbLink, $permittable, "{$incode}='{$permitnumber}'", "owner_id={$owner_id}");

    $getr = FetchRow($dbtype, $get);
    $feedesc = stripslashes($getr[1]);
    $feeamount = $getr[2];
    if ($permit_type != 'Motorized') {
        $ptype = $getr[3];
    } else {
        $ptype = $getr[5];
        $MFees = $getr[7];
    }
    require_once "includes/form_mtop.php";
} elseif ($com == 'Delete') {
    if ($com1 == 'act') {
        $get = SelectDataWhere($dbtype, $dblink, $dtable, "where fee_id = '{$bbo}'");
        $get1 = @mysql_fetch_assoc($get);
        $desc = $get1[fee_desc];
        $exist = SelectDataWhere($dbtype, $dblink, 'ebpls_fess_paid', "where fee_desc = '{$desc}'");
        $exist1 = @mysql_num_rows($get);
        if ($exist1 > 0) {
            ?>
				<body onLoad='javascript:alert ("Cannot Delete, Record exist in other table");'></body>
				<?php 
        } else {
            $delrec = DeleteQuery($dbtype, $dbLink, $dtable, "fee_id='{$bbo}'");
            ?>
		        <body onLoad='javascript:alert ("Fee Deleted"); parent.location="index.php?part=4&class_type=Preference&permit=others&selMode=ebpls_notherfees&action_=8&itemEvent=1&data_item=0";'></body>
<?php 
        }
    } else {
        $delrec = UpdateQuery($dbtype, $dbLink, $dtable, "active=0", "fee_id={$owner_id}");
        ?>
		        <body onLoad='javascript:alert ("Fee DeActivated"); parent.location="index.php?part=4&class_type=Preference&permit=others&selMode=ebpls_notherfees&action_=8&itemEvent=1&data_item=0";'></body>

        }
        if ($istat == 'ReNew') {
            // || $istat=='Retire') {
            require "includes/penalty.php";
        }
    } else {
        echo "0.00";
        $amt2pay[$si + 1] = 0;
    }
    ?>
</td>


<?php 
    //check if no more line to pay
    $hvl = SelectDataWhere($dbtype, $dbLink, "tempbusnature", "where owner_id = {$owner_id} and\n\t\t\tbusiness_id={$business_id} and linepaid=0");
    $hvl = NumRows($dbtype, $hvl);
    //getpayhistory
    if ($balance == '') {
        $balance = $tabs;
    }
    if ($balance >= 0) {
        //echo $cnthave."-".$gethis."<BR>";
        if ($iswev == 1) {
            //$gethis=1;
        }
        if ($gethis == 0 and $hvl > 0 and $amt2pay[$si + 1] > 0) {
            if ($mayunpaid == 1) {
                $unpaid = 2;
            } else {
                $mayunpaid = 1;

?>
</table>
<table border =0 align=left class=sub>
<tr><td></td><td>Total Payments Made:</td><td><font color=red><b>Php <?php 
echo number_format($totpay, 2);
?>
<b></font></td><td></td>
</table>

<?php 
if ($bpar == 1 || $ulev == 6 || $ulev == 7 and $totpay > 0) {
    $ge = SelectDataWhere($dbtype, $dbLink, "havereq", "where owner_id={$owner_id} and\n                                        active=1 and business_id={$business_id}");
    $ge = NumRows($dbtype, $ge);
    $getreq = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_requirements", "where recstatus='A' and reqindicator=1 and permit_type='Business'");
    $gt = NumRows($dbtype, $getreq);
    $gettag = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_preference", "");
    $getre = FetchArray($dbtype, $gettag);
    $checkapp = mysql_query("select * from ebpls_buss_approve a where\n                \t\t\t\t\t\ta.owner_id='{$owner_id}' and\n                                        a.decision=1 and a.business_id={$business_id}");
    $checka = mysql_num_rows($checkapp);
    if ($checka == 0) {
        $gud = 0;
    } else {
        if ($getre[srequire] == 1) {
            if ($ge == $gt) {
                $gud = 1;
            } else {
                $gud = 0;
            }
        } else {
            $gud = 1;
        }

?>
">
<table border =0 width=60% align=center><Br><br>
<tr>
<td> Copy from Line of Business </td>
<td align=center ><?php 
echo get_select_data($dbLink, "fromnat", "ebpls_buss_nature", "natureid", "naturedesc", $fromnat, "true", "naturestatus='A' and natureid<>'{$natureid}' order by naturedesc", "onchange='_FRM.submit();'");
?>
</td>
</tr>
</table>
<table border =0 width=70% align=center><Br>
<?php 
$ic = 0;
$col1 = 0;
$getreq = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_taxfeeother a, ebpls_buss_tfo b", "where a.tfo_id=b.tfoid and a.natureid='{$fromnat}' order by a.mode");
$gt = NumRows($dbtype, $getreq);
while ($ic < $gt) {
    while ($s = FetchArray($dbtype, $getreq)) {
        $ic++;
        if ($col1 == 0) {
            include 'tablecolor-inc.php';
            print "<tr bgcolor='{$varcolor}'>\n";
        }
        if ($s[taxtype] == 1) {
            $lbl = ' (New)';
        }
        if ($s[taxtype] == 2) {
            $lbl = ' (ReNew)';
        }
        if ($s[taxtype] == 3) {

        //$updateveches = UpdateQuery($dbtype, $dbLink, 'ebpls_motorized_vehicles', "transaction = '$stat'",
        //"motorized_operator_id = '$owner_id' and retire = '0'");
        if ($linkpro == 'RELEASING') {
            $checkrentype = @mysql_query("select * from ebpls_motorized_penalty where permit_type = '{$permit_type}'");
            $checkrentype1 = @mysql_fetch_assoc($checkrentype);
            if ($checkrentype1['renewaltype'] == '2' and $stat == "ReNew") {
                $updateit = UpdateQuery($dbtype, $dbLink, "ebpls_motorized_vehicles", "retire = '5'", "motorized_operator_id = '{$owner_id}' and retire = '4'");
                $vbnmyear = date('Y');
                $updateit321 = UpdateQuery($dbtype, $dbLink, "ebpls_motorized_vehicles", "retire = '5'", "motorized_operator_id = '{$owner_id}' and retire = '0' and create_ts like '{$vbnmyear}%'");
                $nbvyear = date('Y');
                $updateit = UpdateQuery($dbtype, $dbLink, "ebpls_fees_paid", "active = '0'", "owner_id = '{$owner_id}' and active = '1' and input_date like '{$nbvyear}%'");
            } elseif ($stat == "Transfer/Dropping") {
                $updateit = UpdateQuery($dbtype, $dbLink, "ebpls_motorized_vehicles", "retire = '2', motorized_operator_id = ''", "motorized_operator_id = '{$owner_id}'  and retire = '1'");
                $nbvyear = date('Y');
                $updateit1 = UpdateQuery($dbtype, $dbLink, "ebpls_fees_paid", "active = '0'", "owner_id = '{$owner_id}' and active = '1' and input_date like '{$nbvyear}%'") or die(mysql_error);
                $checkifmore = SelectDataWhere($dbtype, $dbLink, "ebpls_motorized_vehicles", "where motorized_operator_id = '{$owner_id}'");
                $ifmore = mysql_num_rows($checkifmore);
                if ($ifmore > 0) {
                    $nbvyear = date('Y');
                    $updateit1 = UpdateQuery($dbtype, $dbLink, "ebpls_motorized_operator_permit ", " motorized_no_of_units = '{$ifmore}', transaction = 'ReNew', steps = 'For Payment'", "owner_id = '{$owner_id}' and active = '1' and for_year = '{$nbvyear}'") or die(mysql_error);
                }
            }
            ?>
                <body onload="parent.location='index.php?part=4&class_type=Permits&itemID_=3212&owner_id=<?php 
            echo $owner_id;
            ?>
&com=PrintReport&permit_type=<?php 
            echo $permit_type;
            ?>
&stat=<?php 
            echo $stat;

echo $getmsg[2];
?>
</textarea>
        </td>
        </tr>
        </table>

<table border=1 align=center width=600<br><br>
<tr>
<td align=center>Keyword</td><td align=center>Message</td><td></td>
</tr>
	<?php 
if ($submitbt == 'Search') {
    $sms = SelectDataWhere($dbtype, $dbLink, "sms_message", "where keyword like '{$keyword}%'");
} else {
    $sms = SelectDataWhere($dbtype, $dbLink, "sms_message", "");
}
while ($msg = FetchRow($dbtype, $sms)) {
    $msg[1] = stripslashes($msg[1]);
    $msg[2] = stripslashes($msg[2]);
    ?>
		<tr>
		        <td><input type=hidden name=msgid value=<?php 
    echo $msg[0];
    ?>
>
		            <?php 
    echo $msg[1];
    ?>
			</td>
			<td>

    }
} elseif ($getpended['renewaltype'] == '2') {
    if ($getpended[backtax] == '1') {
        //BackTax Computation for Scenario 2.... Goodluck sakin!!!!!!
        if ($permit_type == 'Motorized') {
            $getvech = @mysql_query("select * from ebpls_motorized_vehicles where motorized_operator_id = '{$owner_id}' and permit_type = 'Motorized' and retire='4' and paid = '0'");
            $totvech = mysql_num_rows($getvech);
            $totalotherpen = 0;
            $totalotherint = 0;
            $totalotherlate = 0;
            while ($getvec = @mysql_fetch_assoc($getvech)) {
                $getlen = strlen($getvec[motorized_plate_no]);
                $getlastnum = substr($getvec[motorized_plate_no], $getlen - 1, $getlen);
                $nsrenewaldate = "renewaldate{$getlastnum}";
                $nmrenewaldate = $getpended[$nsrenewaldate];
                $totvec = SelectDataWhere($dbtype, $dbLink, "ebpls_motorized_vehicles", "where motorized_operator_id = '{$owner_id}' \n\t\t\t\t\t\tand permit_type='{$permit_type}' and retire=0");
                $totvec1 = NumRows($dbtype, $totvec);
                $anongyearngayon = date('Y');
                $getlastnpaydate = @mysql_query("select * from renew_vehicle where owner_id = '{$owner_id}' and motorized_motor_id = {$getvec['motorized_motor_id']} and date_updated not like '{$anongyearngayon}%' and paid = '1' order by date_updated desc limit 1");
                $checkifnotempty = @mysql_num_rows($getlastnpaydate);
                if ($checkifnotempty == 0) {
                    $getlastnpaydate = @mysql_query("select pay_date as date_updated from temppayment where owner_id = '{$owner_id}' and permit_type = 'Motorized' and pay_date not like '{$anongyearngayon}%' order by pay_date desc limit 1");
                }
                $getlastnpaydate = @mysql_fetch_assoc($getlastnpaydate);
                $getlastnpaydate1 = substr($getlastnpaydate[date_updated], 0, 4);
                $lastpaydateyear = $getlastnpaydate1 + 1;
                $lastpaydateyearys = $getlastnpaydate1 + 1;
                $nyeardiff = $yeartoday - $lastpaydateyear;
                $ngyeardiff = $nyeardiff;
                $xloop = 1;
                $backtaxcompute = 0;

<?php

//Module that saves information to table bus_grandamt
//if ($itemID_ == "4212") {
$yearfornow = date('Y');
if (strtolower($pmode) == 'quarterly') {
    $paympart = $qtrcnt;
}
if (strtolower($pmode) == 'semi-annual') {
    $paympart = $semcnt;
}
if (strtolower($pmode) == 'annual') {
    $paympart = '1';
}
if ($ramt2 == 0) {
    $getgh = SelectDataWhere($dbtype, $dbLink, "bus_grandamt", "where owner_id = '{$owner_id}' and business_id = '{$business_id}' and  transaction='{$stat}' and ts = '{$yearfornow}' and paymode = '{$pmode}' and paypart = '{$paympart}'");
    $getghg = FetchRow($dbtype, $getgh);
    $nghigh = $getghg[3];
} else {
    $nghigh = 0;
}
$updatebus = UpdateQuery($dbtype, $dbLink, "bus_grandamt", "active = 0", "owner_id = '{$owner_id}' and business_id='{$business_id}' and ts != '{$yearfornow}'");
if ($nghigh <= 0) {
    $ramt2 = round($ramt2, 2);
    $buspen = round($buspen, 2);
    $busint = round($busint, 2);
    $nbacktax = round($nbacktax, 2);
    $divtax = round($divtax, 2);
    $totalexptax = round($totalexptax, 2);
    //if ($) {
    //	$nbacktax = 0;

        $clr = 1;
    } elseif ($stat == 'ReNew') {
        $result = InsertQuery($dbtype, $dbLink, "tempbusnature", "", "'', '{$bus_code}', '{$bus_nature}',{$oldlay}, \n\t\t\t{$lay},{$owner_id},{$business_id}, now(), \n\t\t\t0, 1,'','ReNew')");
        $luk = SelectDataWhere($dbtype, $dbLink, $permittable, " \n\t\t\t\towner_id={$owner_id} and \n\t\t\t\tbusiness_id={$business_id} \n\t\t\t\tand active=1 and transaction='ReNew'");
        $luk = NumRows($luk);
        if ($luk == 0) {
            $res = InsertQuery($dbtype, $dbLink, $permittable, "\n\t\t\t\t(business_id, owner_id, for_year,\n\t\t\t\tapplication_date,input_by, transaction, \n\t\t\t\tpaid, steps, pin, active)", "{$business_id}, {$owner_id},'{$currdate['year']}', \n\t\t\t\tnow(), '{$usern}', '{$stat}', \n\t\t\t\t0,'For Assessment', '{$pin}', 1");
        }
        $wil = UpdateQuery($dbtype, $dbLink, "tempbusnature", "active=0", "tempid=" . $tempid);
        $bp = UpdateQuery($dbtype, $dbLink, $permittable, "active=0", "owner_id={$owner_id} and business_id={$business_id}\n\t\t\tand active=1");
        $clr = 1;
    } elseif ($stat == 'Retire') {
        $wil = InsertQuery($dbtype, $dbLink, "tempbusnature", "", "'', '{$bus_code}', '{$bus_nature}',{$oldlay},\n                        {$lay},{$owner_id}, {$business_id}, now(),\n                        0, 1,2,'Retire'");
        $updatepermit = UpdateQuery($dbtype, $dbLink, "ebpls_business_enterprise_permit", "pmode='{$pmode}'", "owner_id={$owner_id} and \n\t\t\tbusiness_id={$business_id} order by \n\t\t\tbusiness_permit_id desc limit 1");
        $wil3 = UpdateQuery($dbtype, $dbLink, "ebpls_business_enterprise", "business_payment_mode='Annual'", "owner_id={$owner_id} and business_id={$business_id}");
        $luk = SelectDataWhere($dbtype, $dbLink, $permittable, " where \n\t\t\towner_id={$owner_id} and business_id={$business_id}\n                        and active=1 and transaction='Retire'");
        $luk = NumRows($luk);
        if ($luk == 0) {
            $res = InsertQuery($dbtype, $dbLink, $permittable, "(business_id, owner_id, for_year,\n\t\t\tapplication_date,input_by, transaction, \n\t\t\tpaid, steps, pin, active)", "{$business_id},{$owner_id},'{$currdate['year']}', \n\t\t\tnow(), '{$usern}', '{$stat}', \n\t\t\t0,'For Assessment', '{$pin}', 1");
        }
        $wil = UpdateQuery($dbtype, $dbLink, "tempbusnature", "active=0", "tempid=" . $tempid);
        $bp = UpdateQuery($dbtype, $dbLink, $permittable, "active=0", "owner_id={$owner_id} and business_id={$business_id}\n                        and active=1");
        $clr = 1;
    }
    if ($clr == 1) {
        $dt = DeleteQuery($dbtype, $dbLink, "tempassess", "owner_id={$owner_id} and business_id={$business_id}\n\t\t\tand active=1 and transaction='{$stat}'");
        ?>
	<body onLoad='javascript: opener.location.reload(true); window.close()'></body>
<?php 
    }
}

&busItem=Occupational";'></body>
	           
				<?php 
                }
            }
        }
    }
    //end if occupational
    /*
    if ($owner_id=='') {
    $owner_id=$id;
    }
    */
    if ($permit_type == 'Occupational' || $permit_type == 'Peddlers') {
        $totalvec = 1;
    }
    //need to add drop command
    $getcnt = SelectDataWhere($dbtype, $dbLink, $temptbl, "where owner_id={$owner_id}");
    $cnts = NumRows($dbtype, $getcnt);
    // $lop=1;
    for ($lop = 1; $lop <= $cnts; $lop++) {
        $gettemp = SelectDataWhere($dbtype, $dbLink, $temptbl, "where  owner_id={$owner_id} limit 1");
        $getfee = FetchArray($dbtype, $gettemp);
        $slash = 'add';
        require_once "includes/stripslash.php";
        //insert fees to main table
        $fee_desc = addslashes($getfee[fee_desc]);
        $insertit = InsertQuery($dbtype, $dbLink, "ebpls_fees_paid", "(owner_id, fee_desc, fee_amount, \n\t\t\t\tmulti_by, permit_type, permit_status,\n\t\t\t\tinput_by, input_date)", "{$owner_id}, '{$fee_desc}', {$getfee['fee_amount']}, \n\t\t\t\t{$totalvec}, '{$permit_type}', '{$status}', \n\t\t\t\t'{$usern}', '{$tdate}'");
        $deltemp = DeleteQuery($dbtype, $dbLink, $temptbl, "owner_id ={$owner_id} and \n\t\t\t\t\tpermit_type='{$permit_type}' limit 1");
    }
}

    //$owner_id=$owner_id;
    $owner_first_name = $res[0];
    $owner_middle_name = $res[1];
    $owner_last_name = $res[2];
    if ($tag == 'Occupational' and $permit_type == 'Occupational') {
        //$owner_id = $idcnt;
        require_once "includes/form_add_mtoppermit.html";
        //require_once "includes/form_pay_occu.html";
        $getemp = SelectMultiTable($dbtype, $dbLink, "{$permittable} a, ebpls_business_enterprise b", "a.occ_permit_code,a.occ_permit_application_date, \r\n\t\t\t a.occ_position_applied , b.business_name", "where a.owner_id={$owner_id} and a.business_id=b.business_id");
        $getit = FetchRow($dbtype, $getemp);
        $permit_code = $getit[0];
        $pos_app = $getit[2];
        $permit_date = $getit[1];
        $employer_name = $getit[3];
        require_once "includes/form_pay_midoccu.php";
        require_once "includes/paymtop.php";
    } elseif ($permit_type == 'Peddlers') {
        require_once "includes/form_add_mtoppermit.html";
        $getemp = SelectDataWhere($dbtype, $dbLink, $permittable, "where owner_id={$owner_id}");
        $getit = FetchArray($dbtype, $getemp);
        $merchandise = stripslashes($getit[merchandise_sold]);
        $peddler_bus = stripslashes($getit[peddlers_business_name]);
        $apply = $getit[application_date];
        $permid = $getit[peddlers_permit_id];
        require_once "includes/form_pay_midpeddler.html";
        require_once "includes/paymtop.php";
    } else {
        require_once "includes/form_add_mtoppermit.html";
        require_once "includes/paymtop.php";
    }
}

<?php

/* Purpose: Approval processing

Modication History:
2008.05.06 RJC Define undefined to clean up phperror.log
*/
require_once "includes/variables.php";
$PROCESS = isset($PROCESS) ? $PROCESS : '';
//2008.05.06 define undefined
$com = isset($com) ? $com : '';
if ($com != 'approve') {
    // process successful
    if ($PROCESS == 'SAVE' || $PROCESS == 'PAYMENT') {
        $dec_comment = addslashes($dec_comment);
        $getapp = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_approve", "where owner_id = {$owner_id} and \n\t\t\t\t business_id={$business_id}");
        $getnum = NumRows($dbtype, $getapp);
        if ($getnum == 0) {
            $savedata = InsertQuery($dbtype, $dbLink, "ebpls_buss_approve", "", "'',{$owner_id}, {$business_id}, {$decide}, \n\t\t\t\t '{$dec_comment}', '{$stat}'");
        } else {
            $updata = UpdateQuery($dbtype, $dbLink, "ebpls_buss_approve", "decision={$decide},dec_comment='{$dec_comment}', \n\t\t\t\t transaction='{$stat}'", "owner_id = {$owner_id} and business_id={$business_id}");
        }
        if ($decide == 1) {
            $updateit = UpdateQuery($dbtype, $dbLink, $permittable, "steps='For Payment'", "owner_id={$owner_id} and business_id={$business_id}");
        }
        if ($PROCESS == 'PAYMENT' and $decide == 1) {
            ?>
			<body onload="parent.location='index.php?part=4&newpred=<?php 
            echo $newpred;
            ?>
&noregfee=<?php