Updated Fields but not where i ask

[qadeer_ahmad]

dear Friend my query working and updating feildes but as i ask to update with a seeking of one record its not work query is

$custno=2100;

$date1 = "2004/08/23";
$date2 = "2004/08/29";
$handle = @fopen("http://localhost/unitscustomerspecie.php?cust=".$custno, "rb");
$contents = "";
//print $handle;
if($handle)
{
do {
$data = fread($handle, 8192);
if (strlen($data) == 0) {
break;
}
$contents .= $data;
// print $contents;
} while (true);
fclose($handle);

$contents=trim($contents,"@@");
//print "" .$contents. "CONTENTS OF SLPROJ";
$temp=explode("@@",$contents);
//print count($temp). "count test";
//print "<b>temp: </b>".$temp[0]."<p>";
for($zzz=0;$zzz < count($temp); $zzz++)
{
$temp3=explode("^{",$temp[$zzz]);}
$units[]=$temp3[0];
$Customer[]=$temp3[1];
$speciecode[]=$temp3[2];
print "<p><b>UNITS</b>".$units[$zzz]."><p>";
print "<b>CUSTOMER</b>".$Customer[$zzz]."<p>";
print "<b>SPECIECODE</b>".$speciecode[$zzz]."<p>";
print "UPDATE tblReport Set BudgetUnits=".$units[$zzz]." WHERE specieCode=".$speciecode[$zzz];
// $res_units=mysql_query("UPDATE tblReport Set BudgetUnits = ".$units[$zzz]." WHERE specieCode = ".$speciecode[$zzz]."");
$res_units = "UPDATE tblReport Set BudgetUnits=".$units[$zzz]." WHERE specieCode=".$speciecode[$zzz];
$result5=mysql_query($res_units)or die("could not Update Records");

// $res_units=mysql_query("UPDATE tblReport Set BudgetUnits = 200 WHERE specieCode = 32");
//$res_units="UPDATE tblReport Set BudgetUnits = ".$units[$zzz]." where specieCode = ".$speciecode[$zzz];
}
}

?>

when i execute this page i see these massage

UNITS45>

CUSTOMER2100

SPECIECODE32

UPDATE tblReport Set BudgetUnits=45 WHERE specieCode=32

UNITS197>

CUSTOMER2100

SPECIECODE34

UPDATE tblReport Set BudgetUnits=197 WHERE specieCode=34

UNITS65>

CUSTOMER2100

SPECIECODE35

UPDATE tblReport Set BudgetUnits=65 WHERE specieCode=35

UNITS80>

CUSTOMER2100

SPECIECODE38

UPDATE tblReport Set BudgetUnits=80 WHERE specieCode=38

UNITS69>

CUSTOMER2100

SPECIECODE39

UPDATE tblReport Set BudgetUnits=69 WHERE specieCode=39

UNITS3>

CUSTOMER2100

SPECIECODE43

UPDATE tblReport Set BudgetUnits=3 WHERE specieCode=43

UNITS25>

CUSTOMER2100

SPECIECODE44

UPDATE tblReport Set BudgetUnits=25 WHERE specieCode=44

UNITS19>

CUSTOMER2100

SPECIECODE45

but when i see the result from database directly its no ok it update BudgetUnits but put the value in starting feilds not seeking the specieCode ..... so its totaly wrong result to mee please guid me
like above result

UNITS45>

CUSTOMER2100

SPECIECODE32

in database abainst speciecode 32 thier must be Units 45 but in database thier is nothing unints against 32 spepciecode
and look this one

UNITS80>

CUSTOMER2100

SPECIECODE38

UNITS69>

CUSTOMER2100

SPECIECODE39

against speciecode 38 in databsae thier must be 80 units but thier is 39 and thier is nothig againt 39 specicode

i am confuse much what is this and where it is going???

Pleas Guid me

[paulnaj]

Hi qadeer_ahmad,

I've tidied up the format of your code so that I could see what was going on. There is no way I can check this code except by eye so there may be a few typo's.

It could be a couple of things ...

1) You are trimming '@@' from $contents from one line and then trying to explode on '@@' on the next line. This doesn't seem right. Check the ouput from the script now, to see if it this IS the right thing to do.
2) In the for loop (on $zzz), you are making arrays of $units, etc. Doesn't seem to be any need!!

<? 
$custno = 2100; 
if(!$handle = @fopen("http://localhost/unitscustomerspecie.php?cust=".$custno, "rb")){
	die("Could not open unitscustomerspecie.php?cust=".$custno);
}

$contents = "";
do{
	$data = fread($handle, 8192);
	if(strlen($data) == 0)	break;
	$contents .= $data;
} while (true);
fclose($handle);

echo '<h5>$contents BEFORE trim on "@@"</h5><pre>'.$contents.'</pre><hr>';
$contents = trim($contents, "@@");
echo '<h5>$contents AFTER trim on "@@"</h5><pre>'.$contents.'</pre><hr>';
$temp = explode("@@", $contents);
echo '<h5>$temp AFTER explode on "@@"</h5><pre>';	print_r(htmlspecialchars($temp));	echo '</pre>';

echo '<table border="1" cellpadding="2" cellspacing="0">
<tr><th>UNITS</th><th>CUSTOMER</th><th>SPECIECODE</th></tr>';
for($zzz = 0; $zzz < count($temp); $zzz++){
	$temp3 = explode("^^", $temp[$zzz]);
	$units = $temp3[0];
	$Customer = $temp3[1];
	$speciecode = $temp3[2];
	echo '<tr><td>'.$units.'</td><td>'.$Customer.'</td><td>'.$speciecode.'</td></tr>';
}
echo '</table>';
?> 

See how this code runs ... come back if you are still having problems.

Paul.

[qadeer_ahmad]

browsing result is ...

$contents BEFORE trim on "@@"
9^{2100110@@252100322@@}

---

$contents AFTER trim on "@@"
9^{2100110@@252100322}

---

$temp AFTER explode on "@@"

Warning: htmlspecialchars() expects parameter 1 to be string, array given in C:\Program Files\Apache Group\Apache2\htdocs\freshislandfish\checkforslproj.php on line 19

UNITS CUSTOMER SPECIECODE
9 2100 110
25 2100 322

[paulnaj]

Ok,

Fix that glitch ... take out the call to htmlspecialchars() ...

echo '<h5>$temp AFTER explode on "@@"</h5><pre>'; print_r($temp); echo '</pre>';

But, what about the rest? I cannot 'guess' whether the data is in your database is correct, or is being retrieved correctly.

Paul.