PHP search script for MySQL database returns no records

joe80x86 · August 11, 2009

Ok, I have the following script which is supposed to search a mysql database and return records depending on the user choices. We recently moved the hosting to a new server running iis7, mysql 5.1, and php 5.2.10. The script worked on the old server which was running an older version of php, mysql, and apache. I should note that I did not write the program and the person who did is currently unavailable.

Here is the script. Any suggestions are appreciated.

#submit{

color:white;

background:#003399;

cursor:pointer;

}

</style>

<?php

///////////////////////////////////////////start second report below

if(isset($_POST['change'])== FALSE && isset($_POST['submit'])== FALSE && isset($_GET['name'])== FALSE){

echo "<script type='text/javascript'>

window.location='index.php';

</script>";

}else{

if (isset($_POST['submit'])== TRUE || isset($_GET['name'])== TRUE){

if(isset($_GET['name'])== TRUE){

$_POST['name']=$_GET['name'];

}

$bad = array("/\\\\/","/(')/i",'/(")/i');

$replace= array("\", "&#39", "&#34" );

$name=preg_replace($bad, $replace, $_POST['name']);

if($_POST['et']=="on"){

$to=date('Y-m-d');

}else{

if(isset($_GET['to'])==TRUE){

$to=$_GET['to'];

}else{

$to= $_POST['toy']."-".$_POST['tom']."-".$_POST['tod'];

}

if(isset($_GET['from'])==TRUE){

$from=$_GET['from'];

}else{

$from= $_POST['fromy']."-".$_POST['fromm']."-".$_POST['fromd'];

}

if($to=="--"){

$to="9999-99-99";

}

if($from=="--"){

$from="0000-00-00";

}

if($to==$from){

$d=$_POST['tod']-01;

if($d==0){$d='0'.$d;}

if($d==1){$d='0'.$d;}

if($d==2){$d='0'.$d;}

if($d==3){$d='0'.$d;}

if($d==4){$d='0'.$d;}

if($d==5){$d='0'.$d;}

if($d==6){$d='0'.$d;}

if($d==7){$d='0'.$d;}

if($d=={$d='0'.$d;}

if($d==9){$d='0'.$d;}

$from=$_POST['toy']."-".$_POST['tom']."-".$d;

}

$con=mysql_connect("localhost","xxx","xxx") or die ('Error: '.mysql_error ());

mysql_select_db("xxx");

//bill_day

//to hit bill date

if($_POST['echeck']=="on" || $_GET['echeck']=="on"){

$bill_day= "bill_day='".$to."'";

$entry_day= "o_pm='".$to."'";

$adjfront= "adj_front_date='".$to."'";

$adjclose= "adj_close_date='".$to."'";

$adjrebut= "adjrebut_pd='".$to."'";

$echeck='on';

}else{

$bill_day="bill_day BETWEEN '".$from."' AND '".$to."'";

$entry_day="o_pm BETWEEN '".$from."' AND '".$to."'";

$adjfront= "adj_front_date BETWEEN '".$from."' AND '".$to."'";

$adjclose= "adj_close_date BETWEEN '".$from."' AND '".$to."'";

$adjrebut= "adjrebut_pd BETWEEN '".$from."' AND '".$to."'";

$echeck='off';

}

$total=0;

//start of search loop

$result1=mysql_query("SELECT * From clients WHERE adv='".$name."' AND ".$entry_day);

while($fronter_row=mysql_fetch_array($result1)){

$lname=$fronter_row['lname'];

$date=$fronter_row['bill_day'];

$edate=$fronter_row['o_pm'];

$fronter=$fronter_row['adv'];

$fronter_pay="";

$adj_front_pay="";

$billing_status=$fronter_row['b_status'];

$genie=$fronter_row['o_py'];

$id=$fronter_row['id'];

$sell=$fronter_row['tfee'];

$insert=mysql_query("INSERT INTO temp (adj_front_date, edate, date,fronter, fronter_pay, billing_status, genie, id, entry_date, adj_front_pay, type, closer, closer_pay, rebut, rebut_pay, adj_close_date, adj_close_pay, adjrebut_pay ) VALUES('".$sell."', '".$edate."', '".$date."', '".$fronter."', '".$fronter_pay."', '".$billing_status."', '".$genie."', '".$id."', '".$lname."', '".$adj_front_pay."' , 'activity','','','','','','','');");

}

$result2=mysql_query("SELECT * From clients WHERE cl='".$name."' AND ".$entry_day);

while($closer_row=mysql_fetch_array($result2)){

$lname=$closer_row['lname'];

$adj_close_pay="";

$date=$closer_row['bill_day'];

$edate=$closer_row['o_pm'];

$closer_pay="";

$closer=$closer_row['cl'];

$billing_status=$closer_row['b_status'];

$genie=$closer_row['o_py'];

$id=$closer_row['id'];

$sell=$closer_row['tfee'];

$insert=mysql_query("INSERT INTO temp (adj_front_date, edate, date, closer, closer_pay, billing_status, genie, id, entry_date, adj_close_pay, type, fronter, fronter_pay, rebut, rebut_pay, adj_close_date, adj_front_pay, adjrebut_pay ) VALUES('".$sell."', '".$edate."', '".$date."', '".$closer."', '".$closer_pay."', '".$billing_status."', '".$genie."', '".$id."', '".$lname."', '".$adj_close_pay."', 'activity','','','','','','','');");

}

$result3=mysql_query("SELECT * From clients WHERE rebut='".$name."' AND ".$entry_day);

while($res_row=mysql_fetch_array($result3)){

$lname=$res_row['lname'];

$date=$res_row['bill_day'];

$edate=$res_row['o_pm'];

$rebut_pay="";

$adj_rebut_pay="";

$rebut=$res_row['rebut'];

$billing_status=$res_row['b_status'];

$genie=$res_row['o_py'];

$id=$res_row['id'];

$sell=$res_row['tfee'];

$insert=mysql_query("INSERT INTO temp (adj_front_date, edate, date, rebut, rebut_pay, billing_status, genie, id, entry_date, adjrebut_pay, type, closer, closer_pay, fronter, fronter_pay, adj_close_date, adj_close_pay, adj_front_pay ) VALUES('".$sell."', '".$edate."', '".$date."', '".$rebut."', '".$rebut_pay."', '".$billing_status."', '".$genie."', '".$id."', '".$lname."', '".$adj_rebut_pay."', 'activity','','','','','','','');");

}

//next set billed date

$result4=mysql_query("SELECT * From clients WHERE billed='on' AND cl_py<1 AND adv='".$name."' AND ".$bill_day);

while($fronter_row=mysql_fetch_array($result4)){

$lname=$fronter_row['lname'];

$date=$fronter_row['bill_day'];

$edate=$fronter_row['o_pm'];

$fronter=$fronter_row['adv'];

$fronter_pay=$fronter_row['adv_pay'];

$adj_front_pay="";

$billing_status=$fronter_row['b_status'];

$genie=$fronter_row['o_py'];

$id=$fronter_row['id'];

$sell=$fronter_row['tfee'];

$insert=mysql_query("INSERT INTO temp (adj_front_date, edate, date,fronter, fronter_pay, billing_status, genie, id, entry_date, adj_front_pay, type, closer, closer_pay, rebut, rebut_pay, adj_close_date, adj_close_pay, adjrebut_pay ) VALUES('".$sell."', '".$edate."', '".$date."', '".$fronter."', '".$fronter_pay."', '".$billing_status."', '".$genie."', '".$id."', '".$lname."', '".$adj_front_pay."' , 'bill','','','','','','','');");

}

$result5=mysql_query("SELECT * From clients WHERE billed='on' AND cl_pd<1 AND cl='".$name."' AND ".$bill_day);

while($closer_row=mysql_fetch_array($result5)){

$lname=$closer_row['lname'];

$adj_close_pay="";

$date=$closer_row['bill_day'];

$edate=$closer_row['o_pm'];

$closer_pay=$closer_row['cl_pay'];

$closer=$closer_row['cl'];

$billing_status=$closer_row['b_status'];

$genie=$closer_row['o_py'];

$id=$closer_row['id'];

$sell=$closer_row['tfee'];

$insert=mysql_query("INSERT INTO temp (adj_front_date, edate, date, closer, closer_pay, billing_status, genie, id, entry_date, adj_close_pay, type, fronter, fronter_pay, rebut, rebut_pay, adj_close_date, adj_front_pay, adjrebut_pay ) VALUES('".$sell."', '".$edate."', '".$date."', '".$closer."', '".$closer_pay."', '".$billing_status."', '".$genie."', '".$id."', '".$lname."', '".$adj_close_pay."', 'bill','','','','','','','');");

}

$result6=mysql_query("SELECT * From clients WHERE billed='on' AND rebut_pd<1 AND rebut='".$name."' AND ".$bill_day);

while($reb_row=mysql_fetch_array($result6)){

$lname=$reb_row['lname'];

$date=$reb_row['bill_day'];

$edate=$reb_row['o_pm'];

$rebut_pay=$reb_row['rebut_pay'];

$adj_rebut_pay="";

$rebut=$reb_row['rebut'];

$billing_status=$reb_row['b_status'];

$genie=$reb_row['o_py'];

$id=$reb_row['id'];

$sell=$reb_row['tfee'];

$insert=mysql_query("INSERT INTO temp (adj_front_date, edate, date, rebut, rebut_pay, billing_status, genie, id, entry_date, adjrebut_pay, type, closer, closer_pay, fronter, fronter_pay, adj_close_date, adj_close_pay, adj_front_pay ) VALUES('".$sell."', '".$edate."', '".$date."', '".$rebut."', '".$rebut_pay."', '".$billing_status."', '".$genie."', '".$id."', '".$lname."', '".$adj_rebut_pay."', 'bill','','','','','','','');");

}

//next set adjustments

$result7=mysql_query("SELECT * From clients WHERE adv='".$name."' AND ".$adjfront);

while($fronter_row=mysql_fetch_array($result7)){

$lname=$fronter_row['lname'];

$date=$fronter_row['bill_day'];

$edate=$fronter_row['o_pm'];

$fronter=$fronter_row['adv'];

$fronter_pay="";

$adj_front_pay=$fronter_row['adj_front_pay'];

$billing_status=$fronter_row['b_status'];

$genie=$fronter_row['o_py'];

$id=$fronter_row['id'];

$sell=$fronter_row['tfee'];

$insert=mysql_query("INSERT INTO temp (adj_front_date, edate, date,fronter, fronter_pay, billing_status, genie, id, entry_date, adj_front_pay, type, closer, closer_pay, rebut, rebut_pay, adj_close_date, adj_close_pay, adjrebut_pay ) VALUES('".$sell."', '".$edate."', '".$date."', '".$fronter."', '".$fronter_pay."', '".$billing_status."', '".$genie."', '".$id."', '".$lname."', '".$adj_front_pay."' , 'adj','','','','','','','');");

}

$result8=mysql_query("SELECT * From clients WHERE cl='".$name."' AND ".$adjclose);

while($closer_row=mysql_fetch_array($result8)){

$lname=$closer_row['lname'];

$adj_close_pay=$closer_row['adj_close_pay'];

$date=$closer_row['bill_day'];

$edate=$closer_row['o_pm'];

$closer_pay="";

$closer=$closer_row['cl'];

$billing_status=$closer_row['b_status'];

$genie=$closer_row['o_py'];

$id=$closer_row['id'];

$sell=$closer_row['tfee'];

$insert=mysql_query("INSERT INTO temp (adj_front_date, edate, date, closer, closer_pay, billing_status, genie, id, entry_date, adj_close_pay, type, fronter, fronter_pay, rebut, rebut_pay, adj_close_date, adj_front_pay, adjrebut_pay ) VALUES('".$sell."', '".$edate."', '".$date."', '".$closer."', '".$closer_pay."', '".$billing_status."', '".$genie."', '".$id."', '".$lname."', '".$adj_close_pay."', 'adj','','','','','','','');");

}

$rebuttal=mysql_query("SELECT * From clients WHERE rebut='".$name."' AND ".$adjrebut);

while($reb_row=mysql_fetch_array($rebuttal)){

$lname=$reb_row['lname'];

$date=$reb_row['bill_day'];

$edate=$reb_row['o_pm'];

$rebut_pay="";

$adj_rebut_pay=$reb_row['adjrebut_pay'];

$rebut=$reb_row['rebut'];

$billing_status=$reb_row['b_status'];

$genie=$reb_row['o_py'];

$id=$reb_row['id'];

$sell=$reb_row['tfee'];

$insert=mysql_query("INSERT INTO temp (adj_front_date, edate, date, rebut, rebut_pay, billing_status, genie, id, entry_date, adjrebut_pay, type, closer, closer_pay, fronter, fronter_pay, adj_close_date, adj_close_pay, adj_front_pay ) VALUES('".$sell."', '".$edate."', '".$date."', '".$rebut."', '".$rebut_pay."', '".$billing_status."', '".$genie."', '".$id."', '".$lname."', '".$adj_rebut_pay."', 'adj','','','','','','','');");

}

//start report

$find=mysql_query("SELECT * FROM temp");

$num_rows=@mysql_num_rows($find);

if($num_rows>0){

echo"<hr/>

<h3>".$name."</h3>";

$activity=mysql_query("SELECT * FROM temp WHERE type='activity' ORDER BY edate");

$amt=mysql_num_rows($activity);

if($amt>0){

echo"<h2>Activity for the period</h2>

<form method='post'><input type='hidden' value='".$num_rows."' name='rowAmount' /><table border='1' style='font-family:'Times New Roman', Times, serif; font-size:14px;'><tr><td>na</td><td>Entry Date</td><td>Bill Date</td><td>Sale Price</td><td>Last Name</td><td>Fronter Name</td><td>Closer Name</td><td>Rebuttal/Dec Spc</td><td>Genie #</td><td>Billing Status</td></tr>";

$integer=1;

while($row = mysql_fetch_array($activity)){

$first=stristr($row['date'], "-");

$first=substr($first,1);

$back=substr($row['date'],0,4);

$date=$first."-".$back;

$efirst=stristr($row['edate'], "-");

$enfirst=substr($efirst,1);

$eback=substr($row['edate'],0,4);

$edate=$enfirst."-".$eback;

$row['fronter_pay']=number_format($row['fronter_pay'],2,'.',',');

$row['closer_pay']=number_format($row['closer_pay'],2,'.',',');

$row['rebut_pay']=number_format($row['rebut_pay'],2,'.',',');

$row['fronter_pay']="$".$row['fronter_pay'];

$row['closer_pay']="$".$row['closer_pay'];

$row['rebut_pay']="$".$row['rebut_pay'];

$row['adj_front_pay']=number_format($row['adj_front_pay'],2,'.',',');

$row['adj_close_pay']=number_format($row['adj_close_pay'],2,'.',',');

$row['adjrebut_pay']=number_format($row['adjrebut_pay'],2,'.',',');

$row['adj_front_pay']="$".$row['adj_front_pay'];

$row['adj_close_pay']="$".$row['adj_close_pay'];

$row['adjrebut_pay']="$".$row['adjrebut_pay'];

$lname=$row['entry_date'];

if($row['closer_pay']==""){$row['closer_pay']="na";}

if($row['fronter_pay']==""){$row['fronter_pay']="na";}

if($row['closer']==""){$row['closer']="na";}

if($row['fronter']==""){$row['fronter']="na";}

if($row['rebut_pay']==""){$row['rebut_pay']="na";}

if($row['rebut']==""){$row['rebut']="na";}

if($row['genie']==""){$row['genie']="na";}

if($row['billing_status']==""){$row['billing_status']="na";}

if($row['adj_front_pay']==""){$row['adj_front_pay']="na";}

if($row['adj_close_pay']==""){$row['adj_close_pay']="na";}

if($row['adjrebut_pay']==""){$row['adjrebut_pay']="na";}

if($date=="-" ){$date="na";}

echo "<tr ><td width='50px' ><a id='submit' style='border:outset white 2px; padding:0px 6px 0px 6px; text-decoration:none; ' href='client.php?client=".$row['id']."'>Select</a></td><td >".$edate."</td><td >".$date."</td><td>".$row['adj_front_date']."</td><td >".$lname."</td><td > ".$row['fronter']."</td><td >".$row['closer']."</td><td>".$row['rebut']."</td><td>".$row['genie']."</td><td >".$row['billing_status']."</td></tr>

";

$integer=$integer+1;

}

echo"</table>";

}

// by bill date

$bil=mysql_query("SELECT * FROM temp WHERE type='bill' ORDER BY edate");

$amtb=mysql_num_rows($bil);

if($amtb>0){

echo"<h2>Commission for the period</h2>

<table border='1' style='font-family:'Times New Roman', Times, serif; font-size:14px;'><tr><td>na</td><td>Entry Date</td><td>Bill Date</td><td>Sale Price</td><td>Last Name</td><td>Fronter Name</td><td>Fronter Payment</td><td>Closer Name</td><td>Closer Payment</td><td>Rebuttal/Dec Spc</td><td>Rebuttal/Dec Payment</td><td>Genie #</td><td>Billing Status</td><td>Make Pay Date Current</td></tr>";

while($rowt = mysql_fetch_array($bil)){

$first=stristr($rowt['date'], "-");

$first=substr($first,1);

$back=substr($rowt['date'],0,4);

$date=$first."-".$back;

$efirst=stristr($rowt['edate'], "-");

$enfirst=substr($efirst,1);

$eback=substr($rowt['edate'],0,4);

$edate=$enfirst."-".$eback;

$rowt['fronter_pay']=number_format($rowt['fronter_pay'],2,'.',',');

$rowt['closer_pay']=number_format($rowt['closer_pay'],2,'.',',');

$rowt['rebut_pay']=number_format($rowt['rebut_pay'],2,'.',',');

$rowt['adj_front_pay']=number_format($rowt['adj_front_pay'],2,'.',',');

$rowt['adj_close_pay']=number_format($rowt['adj_close_pay'],2,'.',',');

$rowt['adjrebut_pay']=number_format($rowt['adjrebut_pay'],2,'.',',');

$lname=$rowt['entry_date'];

if($rowt['closer_pay']==""){$rowt['closer_pay']="na";}

if($rowt['fronter_pay']==""){$rowt['fronter_pay']="na";}

if($rowt['closer']==""){$rowt['closer']="na";}

if($rowt['fronter']==""){$rowt['fronter']="na";}

if($rowt['rebut_pay']==""){$rowt['rebut_pay']="na";}

if($rowt['rebut']==""){$rowt['rebut']="na";}

if($rowt['genie']==""){$rowt['genie']="na";}

if($rowt['billing_status']==""){$rowt['billing_status']="na";}

if($rowt['adj_front_pay']==""){$rowt['adj_front_pay']="na";}

if($rowt['adj_close_pay']==""){$rowt['adj_close_pay']="na";}

if($rowt['adjrebut_pay']==""){$rowt['adjrebut_pay']="na";}

if($date=="-" ){$date="na";}

echo "<tr ><td width='50px' ><a id='submit' style='border:outset white 2px; padding:0px 6px 0px 6px; text-decoration:none; ' href='client.php?client=".$rowt['id']."'>Select</a></td><td >".$edate."</td><td >".$date."</td><td>".$rowt['adj_front_date']."</td><td >".$lname."</td><td > ".$rowt['fronter']."</td><td > $".$rowt['fronter_pay']."</td><td >".$rowt['closer']."</td><td > $".$rowt['closer_pay']."</td><td>".$rowt['rebut']."</td><td > $".$rowt['rebut_pay']."</td><td>".$rowt['genie']."</td><td >".$rowt['billing_status']."</td><td >

</td></tr>

";

$integer=$integer+1;

$btotal=$btotal+$rowt['fronter_pay']+$rowt['closer_pay']+$rowt['rebut_pay'];

}

echo"<tr><td>TOTAL:</td><td>$".$btotal."</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td><input type='submit' name='change' value='Update Record' id='submit'></td></tr></table>";

}

//by adjustment

$adj=mysql_query("SELECT * FROM temp WHERE type='adj' ORDER BY edate");

$amta=mysql_num_rows($adj);

if($amta>0){

echo"<h2>Adjustments for the period</h2>

<table border='1' style='font-family:'Times New Roman', Times, serif; font-size:14px;'><tr><td>na</td><td>Entry Date</td><td>Bill Date</td><td>Sale Price</td><td>Last Name</td><td>Fronter Name</td><td>Fronter Payment</td><td>Adjustment</td><td>Closer Name</td><td>Closer Payment</td><td>Adjustment</td><td>Rebuttal/Dec Spc</td><td>Rebuttal/Dec Payment</td><td>Adjustment</td><td>Genie #</td><td>Billing Status</td><td>Make Pay Date Current</td></tr>";

while($rowa = mysql_fetch_array($adj)){

$first=stristr($rowa['date'], "-");

$first=substr($first,1);

$back=substr($rowa['date'],0,4);

$date=$first."-".$back;

$efirst=stristr($rowa['edate'], "-");

$enfirst=substr($efirst,1);

$eback=substr($rowa['edate'],0,4);

$edate=$enfirst."-".$eback;

$rowa['fronter_pay']=number_format($rowa['fronter_pay'],2,'.',',');

$rowa['closer_pay']=number_format($rowa['closer_pay'],2,'.',',');

$rowa['rebut_pay']=number_format($rowa['rebut_pay'],2,'.',',');

$rowa['adj_front_pay']=number_format($rowa['adj_front_pay'],2,'.',',');

$rowa['adj_close_pay']=number_format($rowa['adj_close_pay'],2,'.',',');

$rowa['adjrebut_pay']=number_format($rowa['adjrebut_pay'],2,'.',',');

$lname=$rowa['entry_date'];

if($rowa['closer_pay']==""){$rowa['closer_pay']="na";}

if($rowa['fronter_pay']==""){$rowa['fronter_pay']="na";}

if($rowa['closer']==""){$rowa['closer']="na";}

if($rowa['fronter']==""){$rowa['fronter']="na";}

if($rowa['rebut_pay']==""){$rowa['rebut_pay']="na";}

if($rowa['rebut']==""){$rowa['rebut']="na";}

if($rowa['genie']==""){$rowa['genie']="na";}

if($rowa['billing_status']==""){$rowa['billing_status']="na";}

if($rowa['adj_front_pay']==""){$rowa['adj_front_pay']="na";}

if($rowa['adj_close_pay']==""){$rowa['adj_close_pay']="na";}

if($rowa['adjrebut_pay']==""){$rowa['adjrebut_pay']="na";}

if($date=="-" ){$date="na";}

echo "<tr ><td width='50px' ><a id='submit' style='border:outset white 2px; padding:0px 6px 0px 6px; text-decoration:none; ' href='client.php?client=".$rowa['id']."'>Select</a></td><td >".$edate."</td><td >".$date."</td><td>".$rowa['adj_front_date']."</td><td >".$lname."</td><td > ".$rowa['fronter']."</td><td > $".$rowa['fronter_pay']."</td><td > $".$rowa['adj_front_pay']."</td><td >".$rowa['closer']."</td><td > $".$rowa['closer_pay']."</td><td > $".$rowa['adj_close_pay']."</td><td>".$rowa['rebut']."</td><td > $".$rowa['rebut_pay']."</td><td > $".$rowa['adjrebut_pay']."</td><td>".$rowa['genie']."</td><td >".$rowa['billing_status']."</td><td >

</td></tr>

";

$integer=$integer+1;

$atotal=$atotal-$rowa['adj_front_pay']-$rowa['adj_close_pay']-$rowa['adjrebut_pay'];

}

$total=$btotal+$atotal;

echo"<tr><td>TOTAL:</td><td>$ ".$atotal."</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td><input type='submit' name='change' value='Update Record' id='submit'></td></tr></table></form> <h2>Total ".$total="$".$total."</h2>";

}

//end of all three

echo" </div>

</div>

</body>

</html>";

$delete=mysql_query("DELETE FROM temp");

}else{

echo "<h1>No results, try something else</h1>";

}

mysql_close($con);

}

//added to update paydate

if (isset($_POST['change'])== TRUE){

$con=mysql_connect("localhost","xxx","xxx") or die ('Error: '.mysql_error ());

mysql_select_db("xxx");

$num=0;

$x=$_POST['rowAmount']+1;

while($num<$x){

$num=$num+1;

if($_POST['paydate'.$num]=='on'){

$pay=date('Y-m-d');

$updateone=@mysql_query("UPDATE clients SET cl_py='".$pay."' WHERE adv='".$_POST['name'.$num]."' AND id='".$_POST['id'.$num]."';") or die(mysql_error());

$updatetwo=@mysql_query("UPDATE clients SET cl_pd='".$pay."' WHERE cl='".$_POST['name'.$num]."' AND id='".$_POST['id'.$num]."';") or die(mysql_error());

$updatethree=@mysql_query("UPDATE clients SET rebut_pd='".$pay."' WHERE rebut='".$_POST['name'.$num]."' AND id='".$_POST['id'.$num]."';") or die(mysql_error());

}else{

$pay='';

}

echo "<script type='text/javascript'>

window.close();

</script>";

mysql_close($con);

}

?>

Sign In

PHP search script for MySQL database returns no records

Recommended Posts

joe80x86

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information