Dear Guru
U can update the record with following
===
$result = mysql_query(UPDATE tax set mwool40_
totqty = $res, $connection) or die(error
updating database);
if (mysql_affected_rows($connection) != 1 (/* no of rows that should be
updated */)
{
die(Update problem) ;
}
The only issue is the where condition that you would put in the query
UPDATE tax set mwool40_totqty = $res where ...
regds
amit
The difference between fiction and reality? Fiction has to make sense.
2011/11/11 Guru™ nagendra802...@gmail.com
Hi All,
I want to update an existing mysql record with another value after
calculating it. Below is the code.
?php
$connection = mysql_connect(localhost, root, ) or die(Error
connecting to database);
mysql_select_db(maha, $connection);
$result = mysql_query(SELECT * FROM tax, $connection) or die(error
querying database);
$i = 0;
while($result_ar = mysql_fetch_assoc($result)){
?
tr ?php if($i%2 == 1){ echo class='body2'; }else{echo
class='body1';}?
td
?php
$res=$result_ar['mwool40_totqty']-10;
echo $res;
?/td
/tr
?php
$i+=1;
}
?
I want to append the $mwool40_totqty value with the calculated one $res.
Let say initially the value of $mwool40_totqty is 50. and after calculation
its value became 40, then the code should edit/alter/update the value in
mysql table with integer 40. Please help me with this.
--
*Best,
*
*Guru™*