Posted by Frankly on 04/23/06 20:05

"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.


Sorry if i made it sound like i can easily do it. it is what i would like
to do and the biggest thing that gets me down about all this is not knowing
if I will.


>
> 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).


I know i dont know the lingo very well but when i say i would like the
database to show up on the web page it wont be for updating the database.
only to let those see what i have. i am going to do a few tutorials, read
over this thread and come back when i have a full understanding what what
this group has already introduced me to. wish me luck on my code and il be
back.

Frank


>
>
>> 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]