I am not sure how to go about creating a function. I have a search script that when returns the result there are 4 specific columns that will have either 11,12,13,14,15 but only one number per column. Order depends on how they enter them in (ex. col_1 = 13, col_2 = 11, col_3 = 15, col_4 = 12 OR col_1 = 11, col_2 = 15, col_3 = 13, col_4 = 12 and so on). Each of the numbers needs to be have a decimal added in the middle (ex. 11 = 1.1, 12 = 1.2 and so on). This is what I have happening right now.
But I have one for each cargo_type. Is it possible to write a function that will do this in a shorter more efficient way?

I hope all that makes sense.

__________________
Trying to learn all I can about PHP. Teach me what you know...

You could replace your code above with:

That works perfect, thank you. Would you mind explaining how that works?

__________________
Trying to learn all I can about PHP. Teach me what you know...

Not 100% sure but i think the:

%0.1F

is the format of it and then it just divides it by 10.

Also, sprintf() is used to format strings i think.

In the most simplest code this could be shown as the following.

All the sprintf function is doing is taking your integer (14) and diving by 10 to give you a float (1.4). The rounding of the numbers, as seen in the sprintf, is necessary merely to limit the number of digits that are displayed subsequent to the decimal point. In the sprintf's example, we are limited to a mere one digit after the decimal point. In my example I don't use any rounding, although if need be we could use round. I have left this out though to keep the example simple.

Although, I do suggest using the sprintf method because it looks better and also you have more control in fewer lines, I hope the code below helps you understand the functionality behind Salathe's solution.

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.

Edit: D'oh, you beat me too it

First we move the decimal point one place to the left (by dividing it by 10), then sprintf formats the result.

%0.1F (or %.nF) == format the value given as a floating point number (F) to one decimal place (0.1, the number after the . is the number of places, so %.4F would be to 4 decimal places and so on).

An alternative way (and a lot less elegant)
sprintf is a very powerful and useful function.

__________________
mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0;
Empty set (0.00 sec)

Thanks for all your help.

__________________
Trying to learn all I can about PHP. Teach me what you know...