below is called from a web page.
First time it is called $true varies from 1 to 0 depending on the results
of the mysql_query ( $ins) results.
Data is updated in foreclose.
Call the page after that true is always 0 and $cnt is 0.
$sel = “SELECT * FROM fidel” ;
$ret = mysql_query($sel);
while($arr = mysql_fetch_array($ret))
{
$sd=$arr[sale_Date];
$ts=$arr[tS_Number];
$ad=$arr[address];
$ct=$arr[city];
$st=$arr[state];
$cn=$arr[county];
$zp=$arr[zip];
$ap=$arr[aPN];
$su=$arr[status];
$no=$arr[nOS_Amt];
$op=$arr[open_Bid_Amt];
$sa=$arr[sold_Amt];
$sl=$arr[sale_Location];
$tr=$arr[trustee];
$tp=$arr[trustee_Phone];
$su=addslashes($su);
$sl=addslashes($sl);
$ins =”UPDATE foreclose SET Sale_Date=’$sd’ , TS_Number=’$ts’, Addr=’$ad’, Cty=’$ct’, St=’$st’,Zp = ‘$zp’, County=’$cn’,Status=’$su’,NOS_Amt=’$no’,Open_Bid_Amt=’$op’,Sold_Amt=’$sa’,APN_No=’$ap’,Sale_Location=’$sl’,Trustee=’$tr’,Trustee_Phone=’$tp’ WHERE APN=’$ap'”;
$result= mysql_query($ins);
if (!$result) {
die(‘Invalid query: ‘ . mysql_error());
}
$true=mysql_affected_rows();
echo “true -“;
echo $what;
echo “<br>”;
If ($what > 0 ) { $cnt=$cnt+1 ; }