Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Automatically calculating, and displaying, somone's BMI in a form field using data the user has submitted in seperate height and weight form fields

View all replies to this thread

Automatically calculating, and displaying, somone's BMI in a form field using data the user has submitted in seperate height and weight form fields

Thread began 2/08/2019 2:27 pm by Nathon Jones Web Design | Last modified 8/18/2020 2:45 pm by Nathon Jones Web Design | 1585 views | 6 replies

8/14/2020 9:27 amelewis93815

The update record server behavior has that column defined as an integer:
$UpdateQuery->bindColumn("MCbmi", "i", "".((isset($_POST["MCbmi"]))?$_POST["MCbmi"]:"") ."", "WA_DEFAULT");

If you change it to double it will allow decimals:
$UpdateQuery->bindColumn("MCbmi", "d", "".((isset($_POST["MCbmi"]))?$_POST["MCbmi"]:"") ."", "WA_DEFAULT");

It may be the same on the insert page.... Also make sure the database column is set as a double instead of integer as well with phpMyAdmin.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.