database estate agent

[webdesigner1]

How hard would it to make a database system similar to http://www.robertsnewby.com/

the one on the left hand side.


Thanks in advance!

David

[stephan.gerlach]

not difficult at all.

could be as simple as this



SELECT * FROM properties WHERE type="sale" AND price >= 100000 AND price <= 200000 ORDER BY price DESC

[webdesigner1]

Thanks for your reply but where would i put the information like that?

David

[yamaharuss]

Is your question about creating the entire database or just how to query a db using price values? Stephan gave a perfect example of querying your db.

[webdesigner1]

I would like to know how to make a database and also how to attach it on a website so it works like a form you enter details and it brings up results.

like price of a house £200,000 - £300,000 and it would bring results up in between that value.


Thanks again.

[yamaharuss]

That's a pretty big question. What type of database are you using? MySQL, MS SQL, MS Access... ??

Also, what programming language are you using?