bhavin_85 Posted March 7, 2007 Share Posted March 7, 2007 hey guys i have a field which is float, it stored the price of an item, i need to create another field called points which times the price by 0.1 and stores that value. how would i do this? can the sql database do it itself or would i need to create a function in php that will convert it then store the points? cheers Link to comment https://forums.phpfreaks.com/topic/41634-solved-calculations-within-a-field/ Share on other sites More sharing options...
trq Posted March 7, 2007 Share Posted March 7, 2007 UPDATE tbl SET points = otherfield * 0.1 May work. Link to comment https://forums.phpfreaks.com/topic/41634-solved-calculations-within-a-field/#findComment-201718 Share on other sites More sharing options...
Snooble Posted March 7, 2007 Share Posted March 7, 2007 if not use the UPDATE sql and just do the calc's in php: $text1 = (echo price of item) $text2 = $text1 * 0.1 UPDATE tablename SET pointsfieldname = $text2 Link to comment https://forums.phpfreaks.com/topic/41634-solved-calculations-within-a-field/#findComment-201724 Share on other sites More sharing options...
bhavin_85 Posted March 7, 2007 Author Share Posted March 7, 2007 ok so i guess from what ur saying ill have to write the code in my form which enters the info into that database, ill have a go at it Link to comment https://forums.phpfreaks.com/topic/41634-solved-calculations-within-a-field/#findComment-201725 Share on other sites More sharing options...
obsidian Posted March 7, 2007 Share Posted March 7, 2007 ok so i guess from what ur saying ill have to write the code in my form which enters the info into that database, ill have a go at it What thorpe is suggesting is to let your SQL do it. I agree with him because you would simply have to write a single query to update all the fields. Once you add your new field, just run the query he posted above, and it will update the whole table for you. Link to comment https://forums.phpfreaks.com/topic/41634-solved-calculations-within-a-field/#findComment-201729 Share on other sites More sharing options...
bhavin_85 Posted March 7, 2007 Author Share Posted March 7, 2007 that worked i just tried it in myphpadmin, how do i get the table to run that query everytime its updated? in myphpadmin? sorry thats probably a total n00b question ??? Link to comment https://forums.phpfreaks.com/topic/41634-solved-calculations-within-a-field/#findComment-201735 Share on other sites More sharing options...
Snooble Posted March 7, 2007 Share Posted March 7, 2007 You can run mysql from .php pages. Just set the query into a variable like so: $sql = "PUT QUERY HERE (e.g. SELECT BLAH FROM BLAH/UPDATE diggerydoo)"; mysql_query($sql) or die ("Couldn't execute $sql: " . mysql_error()); put that in your page and you'll see, replace "PUT QUERY HERE" with the query (rolls eyes) Snooble Link to comment https://forums.phpfreaks.com/topic/41634-solved-calculations-within-a-field/#findComment-201737 Share on other sites More sharing options...
bhavin_85 Posted March 7, 2007 Author Share Posted March 7, 2007 i knewu could run them from php pages, thought there might be a way to make the sql database exectute the query automatically everytime a new row is added cheers guys Link to comment https://forums.phpfreaks.com/topic/41634-solved-calculations-within-a-field/#findComment-201739 Share on other sites More sharing options...
trq Posted March 7, 2007 Share Posted March 7, 2007 thought there might be a way to make the sql database exectute the query automatically everytime a new row is added Depending on your version of mysql you may be able to use triggers. Im not 100% up on there syntax but check the mysql manual. Link to comment https://forums.phpfreaks.com/topic/41634-solved-calculations-within-a-field/#findComment-201746 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.