I'm using MQ Sql to hold my data and now I wish to do a calculation with 1 field and return the value to another field: Eg Field 1 = 100 Field 2 = Field 1 * 15.6 I can edit the Mqsql in php admin, would I just simply add Field 1 * 15.6 to field 1 or do i need to add brackets etc? Thanks Ian Sanlucar de Barrameda

Is this a one-time update that you want to do to the entire database? I don't think you can do that through the MySQL admin - I could be wrong. It would be pretty easy to write a PHP/ASP page to run once that would do it for you. Just do a select statement to return all records and then loop through all of them and update the new column. Just a thought though, is this value ALWAYS going to be (Field 1 * 15.6) or can it change after you have made the update. If it will always be 15.6 times Field-1, then it would just make more sense to modify your code whenever you need that value instead of having two values int he database that might get out of sync. Michael J

Field one is a price, field two will always be the value of field one times by 15.6 (well 166.386 the old Spanish peseta) The current output is in a php file Ian Sanlucar de Barrameda

This is what I've tried.....It doesn't work, but I think I'm on the right line...any tips? Ian Price in Pts: <?php define("pst",166.386); $total=0.00; $total=renderSingleListingItemRaw($listingID, "price_es")*pst ; $total = number_format($total, 2); echo $total; ?> Sanlucar de Barrameda