Archive for September, 2009

Mysql rounding for currency format

Posted by Imran in Mysql on September 23rd, 2009

Most of the time we are used to format float numbers into currency format by PHP (or any front end language) using functions like fprintf(). If we could grab the result formatted from the db, we won’t need to use front end formatting. Mysql function format() is the function we need.
Lets say we have a [...]

,

3 Comments

Build dropdown from Mysql SET or ENUM fields

Posted by Imran in Mysql, PHP, Programming on September 5th, 2009

We need to populate dropdown fields from Mysql SET or ENUM fields pretty often. So here is how I use to do it.
Lets say ‘test’ is a table that has a field, ‘agree’ of type ‘SET’ having values ‘Yes’ and ‘No’. On the front end of my application I want to show a dropdown/select field [...]

,

5 Comments