2 MySql Query questions

UK_Steve

Q1)

I have these values in a rent field in db:

1125 > 950

I want to display results by rent ASC so I'm using

$query="SELECT * FROM lets ORDER BY rent ASC";

but this puts the highest rent first, ie £1125

How can I make them display in the correct order?

Q2)

I have a sales table where by I want to display properties by price. So for example only display properties upto £250,000 etc.

What query could I use to acheive this?

Thanks in advance

Steve

pete_bisby

Q1)

... ORDER BY rent DESC

ASCending is the default for ORDER BY, so it doesn't need to be entered. If you were attempting further sorts o more than one attribute, you would need to place your ASCending/DESCending after each attribute. For example ...

... ORDER BY rent DESC, price ASC, town DESC;

Q2)
As an example ...

SELECT *
FROM sales
WHERE price <=250000;

Or if you wanted to find prices by entering a range ...

SELECT *
FROM sales
WHERE price BETWEEN 150000 AND 250000;

Hope this helps!

UK_Steve

Great thanks Q1 Solved!

Your answer to Q2 also works great but I now have a new problem.

My prices are stored in a DECIMAL field like 250.000 etc

On the page I want to display as £250,000

Could I use preg_replace to replace the . with a , or is there an easier way?

Thanks

Steve

pete_bisby

Try using number_format(), it is a lot simpler to use. If you are unsure of the syntax have a look at the php.net website for all the documentation. Click on the following:

http://www.php.net/number_format

You can use this website to look for any help with all the PHP functions - just enter the function name after php.net.

UK_Steve

Thanks mate problem solved 😃