SELECT FORMAT(yourvalue,2)
- Original Message -
From: "Graeme B. Davis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 06, 2002 10:16 PM
Subject: formatting currency in mysql
> Does anyone have a quick tip on how to format a float/numeric in the
> following currency form
It might be faster to instead of getting the list of cities and then in
seperate queries get all hotels for each city, to just sort by city and
fetch all, and in your application check if it has found a next city
already.
Example in php:
$res=mysql_query('select hotel,city from hotels order by ci