Update a field in mysql table 1

[4x4uk]

I want to retrieve all of the values in a field on a table, modify the value and insert it into another field in the table.
I have got this far but am not sure what to do next

$sql="SELECT (field1) FROM $dbsql ORDER BY id";
$results =mysql_query($sql);
while ($myrow=mysql_fetch_array($results)){
$oldvalue=$myrow["field1"];
$newvalue= $oldvalue*2;
}
Any suggestions
Thanks
Ian It's not a lie if you believe it!

http://www.ne4x4.org.uk/

http://www.ne4x4.org.uk/Ian/

http://www.ne4x4.fsnet.co.uk/beck/

 

[sleipnir214]

You want to multiply field1 by 2 and place that value in field2?

Why not perform a single query:

UPDATE tablename SET field2 = field1 * 2

? Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[4x4uk]

As ever Sleipnir214 you manage to come up with a simple solution. Another pink star
thanks It's not a lie if you believe it!

http://www.ne4x4.org.uk/

http://www.ne4x4.org.uk/Ian/

http://www.ne4x4.fsnet.co.uk/beck/