|
|
Posted by Frankly on 04/22/06 20:53
"J.O. Aho" <user@example.net> wrote in message
news:4av742Fu2a18U1@individual.net...
> 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
ok. I am going to do this. I know it is not going to be easy, it is
something that needs to be done.
I can not tell you how nice it feels to be able to talk to you people about
this.
We live in a big city and deal mostly with multi family homes. some
buildings are taller than 20 stories.
as soon as 1 apartment is no longer available another just like it will pop
up. i am not worried about not being needed. infact it would be like
leaving my wife some life insurance if i can do that for her.
however I am still alive and my wife is out there in the rain right now
showing apartments.
i create and put up ads all day long and on the side trying to learn this
much needed stuff.
I am going to create my 2 tables today and i hope you here wont mind letting
me post what I am doing.
thank you all again.
Frank
Navigation:
[Reply to this message]
|