[Resolved] can't figure out why

[jazappi]

I have this snippet of code that checks to see if a user wants to order an amount of brochures for a single store, or for multiple stores. It works fine with 10,000 or more brochures, but if it is less than that it formats the number wrong. For example if a store ordered 6,000 brochures for 5 stores, I get this in the database, that each store should be receiving 1.2 brochures, when it should be 1200 brouchres. Please help! And thanks in advance.

//This is taking the quantity and dividing it by the stores if the user selects the total for all stores option
if ($print_type == "Per Store"){
	$new_quantity = $quantity;
} else {
	$new_quantity = ($quantity / $count);
}

$quantityformatted = number_format($quantity);

[dalecosp]

Check the manual for [man]number_format[/man]. My guess (I'm not looking at it ATM) is that the way you're calling number_format is putting in a comma which SQL is translating into a decimal point in the European manner.

Seems logical, even if it's not true.

HTH,

[jazappi]

Ahh ha. I figured it out. On my form the value of the 6,000 field was 6,000, well PHP was seeing that as 6 not 6,000 so I change the value to 6000 to match the rest of them. I am sure there is a better way to do that but it is fixed.

Thanks for the reply though.