Posted by J.O. Aho on 04/22/06 20:23

Frankly wrote:

> I think maybe I just better make a very simple web site. Maybe on my
> apartments page I should just show the apartments in price order.

If you manage to get the database to spit out the houses/apartments in price
order, then you can easily sort them by other criteria too.

SELECT * FROM house_table WHERE house_type='apartment' ORDER BY house_price

SELECT * FROM house_table WHERE house_price<300000 ORDER BY house_area

All you need to do is some if-statements in php that detects what the user
wants to know and you make the SQL query after that. It's not that difficult
if you know how to use if-statements (they work quite the same in most of
programming languages).


> dont get me wrong I love trying to figure this stuff out. I love a
> challenge I just dont know if i have enough hours in the day to be updating
> all these properties and learn what i need to.

If you make a "input" page where your wife can insert a new object and another
"edit" page where she can change data for each object with the option to
delete them (don't think she needs them after the house got sold) and lastly a
"search" and "display" page, so that people can search for objects they may
want to buy, you will have managed to make yourself unneeded. In hours I think
this would take maybe 8h if you feel somewhat sure on your skills (no need to
be an expert).


> thank you everyone. it is nice to know there is a place where i can ask
> questions about what i read.

Good luck Frank and if there is something, just write a post here.


//Aho

[Back to original message]